How to Freeze a Row or Column in Google Sheets

Keep your rows fixed to the top!
Michael Michael (175)
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. As an Amazon Associate, we may earn a small affiliate commission at no cost to you when you buy through our links.

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.

We'll show you how to add both easily!
Michael Michael (175)
0

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?