Column Lock in Excel

Excel Column Lock

Column Lock feature in excel is used to avoid any mishaps or undesired changes in data done by mistake by any user, this feature can be applied to a single column or multiple columns at once or separately, after selecting the desired column change the formatting of the cells from locked to unlocked and password protect the workbook which will not allow any user to change the locked columns.

Locking a column can be done in two ways. This can be done by using the freeze panes in excel and by protecting the worksheet by using the review functions of excel. In excel, we may want to lock a column so that the column does not disappear in case the user scrolls the sheet. This particularly happens in the case where we have a large count of headers in a single sheet, and the user needs to scroll the sheet to see the other information that is on the sheet.

When the user scrolls the data, then some of the columns may get lapsed and not be visible to the user. So we can lock the columns from getting scrolled out for the visible area.

Column Lock in Excel

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Column Lock in Excel (wallstreetmojo.com)

How to Lock Column in Excel?

#1 – Locking the First Column of Excel

Lets start.

  1. Go to the View tab from the ribbon and choose the option of “Freeze panes.”


    column lock in excel

  2. Form the freeze panes options, choose the option of “freeze the first column.”


    This will freeze the first column of the spreadsheet.

    Colum lock in excel 1-3

#2 – Lock any other Column of Excel

If the column is to be locked, then we need to follow the below steps.

  • Step #1 – Select the column that needs to be locked. If we want to lock the column “D,” then we need to select the column “E.”
Colum lock in excel 1-4
  • Step #2 – Now from the view tab, choose the option of freeze pane and select the first option to lock the cell.
Colum lock in excel 1-5

The output is shown below:

Colum lock in excel 1-7

#3 – Using the Protect Sheet Feature to Lock a Column

In this case, the user will not be able to edit the content of the locked column.

  • Step #1 Select the complete sheet and change the protection to unlocked cells.
protection to unlocked cells
  • Step #2 – Now select that column that we want to lock and change the property of that cell to “locked.”
Format cells
  • Step #3 – Go to the review tab and click on the protect sheet and click on “OK.” Now the column will be locked.
Colum lock in excel 1-11
protect sheet

Explanation of Column Lock in Excel

Ever wondered what will happen if someone changes the value of a cell or a complete column? Yes, this may happen, especially in cases where the sheet is shared with multiple users of the team.

If this happens then, this may drastically change the data of the sheet as many other columns may depend upon the values of some another column.

So, if we are sharing our file with other users, then we must make sure that the column is protected, and no user is able to change the value of that column. This can be done by protecting the columns and hence locking the columns. If we are locking a column, then we can choose to have a password to unlock a column, or we can choose to continue without a password.

This is about locking the column, but sometimes we just want a specific column that does not lapse in case the sheet is scrolled and always visible on the sheet.

In this case, we need to use the freeze panes option that is available in excel. Using the freeze panes option, we can actually fix the position of a column, and this position does not change even if the sheet is scrolled. By using the freeze panes, we can lock the first column, any other column, or even the lock the rows and columns of excelRows And Columns Of ExcelA cell is the intersection of rows and columns. Rows and columns make the software that is called excel. The area of excel worksheet is divided into rows and columns and at any point in time, if we want to refer a particular location of this area, we need to refer a cell.read more.

Things to Remember

  • If we are locking a column by using the Freeze panes option, then only the column is locked from scrolling, and the content of the column can always be changed anytime.
  • If we are using the Protect Sheet option and Freeze panes option, then this is only possible to protect the content of the column and also protect it from scrolling.
  • If we want that a column that is not the first column that can be freeze, then we need to select the next right column, and then we need to click on freeze panes. Hence this should be remembered that always next column should be selected for freezing the prior column.
  • We can choose to have a password if we are protecting a column, or we can continue without having a password.

Recommended Articles

This has been a guide to Excel Column Lock. Here we discuss how to use Column Lock in Excel using the Freeze Top column along with practical examples and a downloadable excel template. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Reader Interactions

Leave a Reply

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