How to Freeze a Row or Column in Google Sheets

Jun 7, 2021

In this guide, we'll show you how to freeze a row or column in Google Sheets.

What does it mean to "freeze a row" in Google Sheets?

Freezing a row in Google Sheets makes it so that the selected row (or rows) stays at the top of the page, as the user scrolls through the rows of data. This is most useful when you have many rows, but want to keep a header at the top. It's sometimes called sticking a row in Google Sheets.

Freezing a column in Google Sheets

We'll show you how to freeze a row in Google Sheet, and, as a bonus, we'll show you how to freeze a column, too. Freezing a column makes it so that your column will stay as a user scrolls across a spreadsheet.

Google Workspace

Howchoo is reader-supported. As an Amazon Associate, we may earn a small affiliate commission at no cost to you when you buy through our links.

Once you've opened your Google Sheet, highlight a row or column by clicking on its corresponding number. (You can select multiple rows and columns by holding shift when you select the rows or columns.)

Go to View.
Select Freeze.
Choose Up to current row to select all rows up to the one chosen.

It's the same process for freezing columns. Just select Up to current column. By default, Google Sheets sets the frozen rows and columns to the top and left, respectively.

Did you know you can create a CSV file from a Google sheet? Check out our guide to see how it's done.

NEXT UP

Michael (175)

Mar 23, 2021

In this guide, we'll show you how to add both a column and a row to your spreadsheet in Google Sheets. Can I add a blank column or row in Sheets without formatting?

How to Freeze a Row or Column in Google Sheets

What does it mean to "freeze a row" in Google Sheets?

Freezing a column in Google Sheets

Select a row or column you want to freeze

Go to View > Freeze