Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
- Power Bi (35+)
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.
Table of Content
- Locking the First Column of Excel
- Lock any other Column of Excel
- Using the Protect Sheet Feature to Lock a Column
Excel Column Lock
In excel we can lock the column that should not be changed in any way, this may be a case where we have a lot of critical information in a column and that column is a source of data for other functions of the spreadsheet. If this column is edited in any way then this may be possible that the other functions of excel may be disturbed and there may be an error later on.
Locking a column can be done in two ways. This can be done by using the freeze panes 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 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.
How to Lock Column in Excel?
#1 – Locking the First Column of Excel
Step #1: Go to the View tab from the ribbon and choose the option of “Freeze panes”
Step #2: Form the freeze panes options, choose the option of “freeze the first column”.
This will freeze the first column of the spreadsheet.
#2 – Lock any other Column of Excel
If the column that 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 column “D” then we need to select column “E”.
Step #2 – Now from the view tab, choose the option of freeze pane and select the first option to lock the cell.
The output is shown below:
#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.
Step #2 – Now select that column that we want to lock and change the property of that cell to “locked”
Step #3 – Go to the review tab and click on the protect sheet and click on “OK”. Now the column will be locked.
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 that a specific column 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 excel.
Things to Remember about Column Lock in Excel
- If we are locking a column by using Freeze panes option than 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 than this is only possible to protect the content of the column and also the protect it from scrolling.
- If we want that a column that is not the first column can be freeze than 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.
This has been a guide to Excel Column Lock. Here we discuss how to use Column Lock in Excel using Freeze Top column along with practical examples and downloadable excel template. You may learn more about excel from the following articles –