Lock One or More Data Columns on Excel Worksheet - Freeze

This article provides a clear overview of Lock One or More Data Columns on Excel Worksheet - Freeze, with the main facts, useful context, and practical details organized for easy reading.

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.