How do you Freeze Rows in Google Sheets

"Freezing", sometimes called "Locking", your rows is a great way to compare specific rows to the rest of your data. I will show you how to use this technique in three simple steps.

Step #1: Select the Row

How to Freeze Rows in Google Docs in a few easy steps

First, you will click anywhere on the row that you want to freeze. 

You can also click and drag the grey bar at the bottom of the "A1" cell to select what rows are frozen, as well.

Step #2: "View" --> "Freeze"

Freeze Rows in Google Sheets

Next, simply open the "View" drop-down menu and select the "Freeze" tool. That will lead you to the second menu, which will let you specify how you want to freeze your rows.

I usually like to select the "Up to Current Row" option. 

Step #3: Make Sure it Works

How to Freeze Rows

Lastly, you will need to scroll through your data and verify that the freeze actually worked. As you can see in the example image, the row you froze will stay on screen as you scroll down, but the rest of the data will continue to scroll down normally.

And that is how you freeze rows in Google Sheets.

Leave a Reply

Your email address will not be published. Required fields are marked

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Google Sheets Magic Tricks!

Interactive, Easy and Free Way to Learn 5 Awesomely Cool Google Sheets Tricks!