How to Freeze a Row or Column in Google Sheets

Keep your rows fixed to the top!
Michael Michael (179)
0

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 WorkspaceGoogle Workspace ×1

Howchoo is reader-supported. When you buy through links on our site, we may earn a small affiliate commission at no cost to you.

Highlight row Google Sheets

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.)

View and Freeze row or column
  • 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.

Expand what you can do in Google Sheets!
Britt Britt (54)
1 minute

Google Sheets makes it easy to create data spreadsheets that can be used by a team of collaborators.