This Element within Excel allows others to enter or edit information into all other cells except for those which have been locked. Hiding or Locking Cells has no effect at all on the worksheet until you protect the worksheet.

When sharing projects among several team members sometimes it is necessary to lock certain cells within the worksheet to ensure the data isn’t deleted or changed. When the worksheet is shared, the team member will be able to adjust all unlocked cells, however, the locked cells will remain the same.

the worksheet has already been protected

If the worksheet has already been protected, the first step is to unprotect it by clicking the REVIEW tab within the Ribbon and selecting Unprotect Sheet. You may have to enter a password if the worksheet was protected with one originally.
How To Lock Columns In Excel 1


1. Select the whole worksheet by clicking on the select all arrow in the top left of the worksheet (highlighted in picture above).

2. Right click anywhere and select FORMAT CELLS from the menu options or from the HOME Tab click the small arrow at the bottom right of the Font Box or you can simply enter (Control + Shift + F) to have the Format Cells box open.

3. In the PROTECTION Tab of the Format Cells box uncheck Lock Cells and click OK to complete unlock all cells within the worksheet so you can designate the specific cells within the worksheet that you want to lock.

How To Lock Columns In Excel 2

4. Now back on the Worksheet select the column(s) that you would like to Lock. Open the Format Cells box again and this time click to put a checkmark back in the Locked checkbox.

5. Go back to the REVIEW Tab and select PROTECT THIS WORKSHEET.

6. A dialog box will pop-up asking if you would like to password protect the worksheet and there are numerous elements that you can either allow or disallow users to do within the worksheet. The first two elements are selected by default:

         a. Select lock cells – allows users to select cells that are locked but does not allow changes or               deletion

         b. Select unlock cells – allow users to select and make changes within all unlocked cells.

         c. All other elements are in relation to formatting, sorting, inserting/deleting columns and rows                and are not selected by default.

     Once you click OK the worksheet will now be protected. 

7. If someone attempts to make changes into a locked cell the following message will pop-up on the      screen.

How To Lock Columns In Excel To Unlock Columns

you will need to begin by Unprotecting the Sheet under the Review tab. Select the column you have locked and bring up the Format Cells box. Under the PROTECTION tab once again unclick the Locked checkbox.

How To Lock Columns In Excel

Locking cells could also be beneficial at a networking event where each member could enter their information into a worksheet as shown to the left. Column A could be locked in place to ensure that no changes are made, however, members could easily enter their information under each column.