Use the steps below to lock a row in Google Sheets and keep it visible as you scroll.
- Sign into Google Drive and open your Sheets file.
Go to https://drive.google.com as a quicker way to access Google Drive files.
- Click the “View” tab at the top of the window.
If you want to lock more than the top two rows, then you should click on the row number below the last row to lock.
- Choose the “Freeze” option, then select the number of rows to lock.
Note that you can only freeze a set of rows starting from the top of the spreadsheet. You can’t lock rows that are in the middle of the spreadsheet.
There is an alternate method for locking rows in Google Sheets that many people find to be more convenient.
In the cell above the row 1 heading and to the left of the column A heading there is a horizontal gray bar. If you click and drag that bar down you will be able to lock all of the rows above that bar.
The steps in the article above were performed in the desktop version of the Google Chrome Web browser. These steps also work in other desktop browsers like Firefox or Edge.
Large spreadsheets can be difficult to manage as you begin to add more and more rows of data.
Constantly having to scroll back up to the top of the spreadsheet to see what data belongs in which columns can be tedious and error-prone.
Fortunately you can lock a row in Google Sheets so that it stays visible at the top of the page, even when it should be hidden from view as you scroll down.
The steps in the guide above discuss low to lock, or how to freeze, rows in Google Sheets using an option found on the “View” menu.
Frequently Asked Questions
First, select the cell, or group of cells, that you want to lock. Next, click the “Data” tab at the top of the window, then choose the “Protected sheets and ranges” option. Click the “Set Permissions” button then follow the on-screen prompts to set cell permissions.
Open your spreadsheet in Excel, then click the “View” tab at the top of the window. Click the “Freeze Panes” button, then select the option that corresponds to the rows that you want to freeze.
If you’re typing a formula in Google Sheets and you press F4, it lets you toggle between relative and absolute cell references. Typically cell references in a formula will adjust when they’re copied to a different cell, but if you choose to use absolute cell references instead then you can keep those references at their original values.
- How to change the orientation of a printed spreadsheet in Google Sheets
- How to sort a column from high to low in Google Sheets
- How to print with gridlines in Google Sheets
- How to copy multiple rows in Google Sheets
- How to change cell border color in Google Sheets