If you have a very long spreadsheet, you may need to freeze the top row so you won’t lose the labels of the columns.
How can we do this? You might have already noticed a way from the image above! We'll take you through two ways to do so.
Method 1: A Simple Drag by the Mouse
If you go back to the start of the spreadsheet, you would notice a gray bar on the top-left corner as you can see on the image above. If you hover your cursor above it, it will turn light blue. Drag it down to below the Row 1:
Now the Row 1 is still visible on top even if you scroll down:
Method 2: Via View Menu
You can also lock the row by doing the following steps:
Step 1: Select the cells to be kept visible on the top row.
Step 2: Click View on the menu, and then the Freeze option from the drop-down menu, and then select Up to current row.
How to Unlock the Row
There are also two ways to unlock the top row.
Via Mouse: Drag the same bar you moved down back to top of Row 1.
Via View Menu: Click View, then the Freeze option from the drop-down box, and then select No Rows. This will unlock the top row.
Using this knowledge, you will be able read your data more easily in Google Sheets!