September 15, 2020

How to Quickly Freeze/Lock Rows in Google Sheets

Google Sheet spreadsheet
  1. Lock Rows by Dragging the Mouse
  2. Lock Rows via View Menu
  3. How to Unlock Rows

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. 

Row 1 locked on the top of the spreadsheet

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

A gray bar above Row 1 highlighted for dragging down

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:

Gray bar moved to below Row 1, Row 1 now frozen on top

Now the Row 1 is still visible on top even if you scroll down:

Row 1 still visible after scrolling 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

View selected, Freeze selected, and then Up to current row highlighted.
The row is frozen now.

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.

Be careful though! Make sure you are dragging the light blue line. If you dragged the dark blue line you will end up hiding the top row!

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!

Suscribe to get more data and analytics tips!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.