In this article we will show you how to lock a column in google sheets so your column will remain fixed. This is particularly useful when you want to scroll horizontally across a large data set but need the first column to be visible in order to understand what the data in each row is for.
This method involves moving the drag bar to freeze the leftmost columns.
On the upper-left corner of the sheet there is a pair of thick gray bars that you can move, called drag bars. The color changes to blue when you move the cursor over it. The vertical bars is for splitting the sheet to freeze the leftmost columns.
Click the drag bar, then drag it to the right until it covers the columns you want to lock.
This method involves going through the main menu to freeze cells.
You can select the entire column or a single cell belonging to that column.
Google Sheets offer the following options on selecting the columns to lock:
For this step, we select Up to Column A.
No. If you try Method 2 while selecting a column in the middle of the sheet, Google Sheets will still lock the first column which is column A. See the screencap below:
We hope this article has helped you and given you a better understanding of how to lock a column in Google Sheets.
You might also like our articles on how to freeze multiple rows in Google Sheets and how to freeze cells in Google Sheets. On a side note, we also recommend reading our guide on how to have Google Sheets send an email and trying our insurance policy reminder software.
Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.
.png)
