When working on Google Sheets, you may notice that the top row disappears every time you scroll down. It makes the row visible as you scroll down to other cells. If you’re working on a large dataset, you may need to freeze the top row to lock it. Let us discuss some of the common methods used to lock the top row.
Using the mouse or cursor to freeze the top row
Table of Contents
It is the simplest technique for freezing the top row. It involves the use of a mouse or the cursor and these steps:
1. Open the document you want to freeze the top row in Google Sheets. That is, log in to the sheet using a computer. In addition, make sure you have a Google account to access the Google sheet feature.
2. Then, take the cursor to the top-left part of the screen where the numbering of rows and columns starts.
3. Hover the mouse on the empty square until a hand-like cursor is displayed.
4. Using the left-mouse key, drag the hand-like cursor down and bring it below line one.
5. That’s it. Your row one will be frozen.
Using the menu feature in Google Sheet
Another common way to freeze the top row is by using the menu buttons. Here are the steps to so;
1. Open the document you want to freeze the top row in Google Sheets. That is, log in to the sheet using a computer. In addition, make sure you have a Google account to access the Google sheet feature.
2. Then, on the menu section, locate and click on the View option.
3. On the drop-down menu, hover the mouse on the freeze button.
4. Then, select either 1 row or up to row 1. When using the Up to row 1 option, you need first to highlight the top row, then continue from step 2.
5. The top row will be frozen, and you can easily see it while scrolling down other rows.
Highlighting the top row
Here’s another method to freeze the top row.
Steps:
1. Open the document you want to freeze the top row in Google Sheets. That is, log in to the sheet using a computer. In addition, make sure you have a Google account to access the Google sheet feature.
2. Highlight the top row you want to freeze.
3. Then, right-click on the highlighted row. Then hover the cursor on top of the View more row action button.
4. Select the freeze up to row 1 option from the side-view menu.
Using a mobile Phone to freeze the Top row in Google Sheet
Steps:
1. Download and install the sheet mobile application.
2. Open the document you want to freeze in the top row. Make sure you’re logged in.
3. Select the sheet’s drop-down menu.
4. From the menu displayed, scroll down to the freeze rows option.
5. Using either the up or down arrow, set the number of rows to be frozen as 1.