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 .
Lock one or more data columns on Excel worksheet - Freeze data in Excel Picture 1
In the Format Cells dialog box, select the Protection tab and uncheck Locked and click OK .
Lock one or more data columns on Excel worksheet - Freeze data in Excel Picture 2
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.
Lock one or more data columns on Excel worksheet - Freeze data in Excel Picture 3
Reappears the Format Cells dialog box, select the Protection tab , select Locked and click OK .
Lock one or more data columns on Excel worksheet - Freeze data in Excel Picture 4
Step 3: You can choose Review -> Protect Sheet (or Home -> Format -> Protect Sheet ).
Lock one or more data columns on Excel worksheet - Freeze data in Excel Picture 5
The Protect Sheet dialog box appears, enter the password in the Password to unprotect sheet box -> OK .
Lock one or more data columns on Excel worksheet - Freeze data in Excel Picture 6
Confirm the password in Reenter password to proceed -> OK .
Lock one or more data columns on Excel worksheet - Freeze data in Excel Picture 7
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.
Lock one or more data columns on Excel worksheet - Freeze data in Excel Picture 8
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
- How to Freeze Cells in Excel
- Steps to lock columns in Excel
- 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
- Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells
- How to compare data on 2 columns in an Excel file