How to lock columns in Excel

 242 total views

2021-06-01 19:46:20

Locking columns in Excel with a password helps you protect columns, prevent others from changing column content or editing columns, affecting the entire data of the table. This helps others to still be able to see the content without having to set the password of the Excel file to hide the entire content or have to perform the operation of hiding columns in Excel. The following article will guide you how to lock columns in Excel.

Instructions for locking columns in Excel

Step 1:

You open the Excel file, you need to do the column locking black out the entire Excel table. Then click anywhere in the data and Select Format Cells… in the displayed list.

Step 2:

Now display the new interface, we click on Protection tab and uncheck the box in Locked. This operation helps to completely remove the lock for the Excel file, click OK to save it.

Unlock files

Step 3:

Going back to the data sheet, highlight the column to be locked then right click and select Format Cells. Then tick the box Protection tab and check box in Locked to lock this column only. If you want to lock multiple columns, highlight those columns.

Select 1 column key

Step 4:

Also click on that column again and then click on Review tab on the Ribbon.

Click Review

Then look down below at group Protect click Protect sheet feature.

Security sheets

Now display the new window interface, you enter your own password mine at o Password to unprotect sheet to proceed to lock the selected Excel data column with a password and then click OK to save.

Enter password

So when you click on this data column, the message will be displayed as shown below. Others cannot click on the column to proceed with content editing.

Column lock notice

Step 5:

To unlock Excel column, you click again Review tab then choose Unprotect Sheet to remove the password. We will then be asked to enter the password we used before to unblock the Excel column.

Unlock the column


#lock #columns #Excel

Leave a Reply

Your email address will not be published. Required fields are marked *