Steps to lock columns in Excel
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 hidden column manipulation 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 to lock the column and then 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 the Protection tab and uncheck the Locked item . This operation helps to completely remove the lock for the Excel file, click OK to save it.
Steps to lock columns in Excel Picture 1
Step 3:
Return to the data table, highlight the column to be locked, then right-click and select Format Cells . Then check the Protection tab and check the Locked section to lock this column only. If you want to lock multiple columns, highlight those columns.
Steps to lock columns in Excel Picture 2
Step 4:
Also click on that column again and then click on the Review tab on the Ribbon.
Steps to lock columns in Excel Picture 3
Then look down below in the Protect group and click on the Protect sheet feature .
Steps to lock columns in Excel Picture 4
Now display the new window interface, enter your own password in the Password to unprotect sheet box to proceed to lock the selected Excel data column with the password and then click OK to save.
Steps to lock columns in Excel Picture 5
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.
Steps to lock columns in Excel Picture 6
Step 5:
To unlock the Excel column , click the Review tab again and select Unprotect Sheet to remove the password. We will then be asked to enter the password we used before to unblock the Excel column.
Steps to lock columns in Excel Picture 7
You should read it
- MS Excel - Lesson 4: Working with lines, columns, sheets
- How to delete, add columns in Excel
- 2 ways to separate column Full and Name in Excel
- How to number columns automatically in Excel
- How to set a password for a column of data in excel
- How to keep Excel and Excel columns fixed?
- Ways to hide data on Excel
- Instructions for separating column content in Excel
- The way to color alternating columns in Excel is extremely simple
- How to Move Columns in Excel
- How to black out rows or columns in Excel with keyboard shortcuts
- Column order in Excel is reversed, why and how to handle it?
May be interested
Installation steps to automatically save Excel files to OneDrive
How to view and restore Excel file versions phiên
Steps to restore the default Font in Microsoft Office
Steps to cancel automatic numbering in Word
What is the size of A5 paper? How to select and print A5 paper in Word
How to open the formula management window in Excel