What are Lock Columns?
To keep an area of a worksheet visible while you scroll to another area of the worksheet, you can lock specific rows or columns in one area by freezing or splitting panes.
How To Lock Columns In Excel In South Africa?
After unlocking all cells, select the column(s) you wish to lock. Right-click and choose Format Cells. In the Protection tab, check the Locked box. This step defines which columns will be locked.
How do I add a password to a column in Excel?
Select the cells you want to protect.
Right-click on them and select Format Cells.
Go to the Protection tab and check the Locked checkbox.
Select OK.
The selected cells will be locked once you password-protect the worksheet.
How do I keep columns fixed in Excel?
Select View > Freeze Panes > Freeze First Column.