Lock one or more data columns on Excel worksheet - Freeze data in Excel
For those of you who often work with Excel spreadsheets, it's probably very simple to lock one or more columns of data on a spreadsheet. But for those new to Excel, it will be difficult to lock one or more columns of data on an Excel spreadsheet. To help you easier when you need to lock data columns in Excel, the following article will help you do this.
To lock one or more columns of data on an Excel spreadsheet, do as follows:
Step 1: Open the sheet containing the data columns to be locked, then select all sheets by pressing Ctrl + A key combination . Then right-click and choose Format Cells .
In the Format Cells dialog box, select the Protection tab and uncheck Locked and click OK .
Step 2: Select the column or multiple columns of data to lock, then right-click and select Format Cells . For example, if you lock the Student ID and Student Name columns, then select the Student ID and Student Name columns.
Reappears the Format Cells dialog box, select the Protection tab , select Locked and click OK .
Step 3: You can choose Review -> Protect Sheet (or Home -> Format -> Protect Sheet ).
The Protect Sheet dialog box appears, enter the password in the Password to unprotect sheet box -> OK .
Confirm the password in Reenter password to proceed -> OK .
So the data columns you have selected are locked, to unlock you go to Review -> Unprotect Sheet (or Home -> Format -> Unprotect Sheet ) then enter the password into the Unprotect Sheet dialog box and click OK to Unlock data area.
Hopefully, with the steps detailed in the article, you do not know how to lock one or more columns of data on Excel spreadsheets will be able to do it.
Good luck!
You should read it
- Video tutorial using Freeze feature - fixed column, line in Excel
- How to Compare Data in Excel
- How to fix columns in Excel
- MS Excel 2007 - Lesson 5: Edit Worksheet
- How to convert columns into rows and rows into columns in Excel
- How to Insert Headlines in Excel
- Instructions for formatting data in Excel
- Format Excel 2007 spreadsheet
May be interested
- Lock a range of data on Excel spreadsheetsafter you have finished processing data in excel spreadsheets, sometimes for some reason you do not want others to edit the data of a range of data in excel spreadsheets.
- Collection of the most beautiful cover templateshere share the beautiful cover template in word for you to choose.
- Round a number in Excelthe following article shows you how to round decimal places after commas in excel.
- How to draw pictures and diagrams in Wordmicrosoft word not only supports you to edit documents but also supports you with many features, it provides us with drawing tools and drawing diagrams easily and conveniently.
- How to split 1 cell into 2 cells in Excel - Split cells in Excelhow to split 1 cell into 2 cells in excel - split cells in excel. depending on different purposes, you want to split a cell into two cells to enter two different data in one cell and still be able to calculate normally as other cells.
- Attach document to word file - Attach file in wordattach document to word file - attach file in word. the following article shows you how to attach files to word.