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.

In google sheets, when you lock a row, it will keep all of the data in and above that row visible as you scroll through the chart. Someone may lock a row in google sheets if they want to compare a certain segment of data to the rest of the table.

I will show you how to freeze any line in google sheets with these three simple steps.

Step #1: Select the R

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/lock

You can also click and drag the grey bar at the bottom of the "A1" cell to select what rows are frozen, as well. You can lock any rows that you want thanks to google sheets.

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.

Google lets you freeze multiple rows, and even freeze columns if you want to.

Alternatively, if you wan to unfreeze rows that were previously frozen, you can just follow the same steps, but select "unfreeze" to begin un-freezing rows/columns.

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"}