Skip to content
AnIntent

How to Freeze Rows and Columns in Google Sheets (and Unfreeze Them)

Freeze or unfreeze rows and columns in Google Sheets on a computer or Android, and when to group or hide them instead.

AnIntent Editorial · · 4 min read

Person working on a laptop with a spreadsheet outdoors
Photo by Gorilla ROI Data Connector on Unsplash
In this article
  1. Freeze rows or columns on a computer
  2. Freeze or unfreeze rows in the Android app
  3. Freezing is not hiding
  4. Group rows when you want to collapse sections
  5. Which one to use
  6. Limits Google doesn't spell out
Share this article

To freeze rows in Google Sheets, use View > Freeze on a computer, or touch and hold a row in the Android app. Your header row or label column then stays on screen while you scroll. Below are the steps for both, how to undo them, and when grouping or hiding fits better. This guide covers the computer and Android versions only; it does not include steps for the iPhone and iPad app.

Freeze rows or columns on a computer

These steps come from Google's Docs Editors Help page for the computer version:

  1. Open the spreadsheet in Google Sheets.
  2. Select a row or column you want to freeze.
  3. At the top, click View, then Freeze.
  4. Choose how many rows or columns to freeze.

To keep a header in place, freeze the top row. To keep names or IDs visible while you scroll right, freeze columns instead. The same menu handles both.

Unfreeze rows or columns on a computer

  1. Select a row or column.
  2. Click View, then Freeze.
  3. Choose No rows or No columns.

Rows and columns are handled separately. If you froze both, pick No rows and No columns one after the other to clear everything.

Freeze or unfreeze rows in the Android app

Google's Android version of the same help page lists three steps:

  1. Open the spreadsheet in the Google Sheets app.
  2. Touch and hold a row or column.
  3. In the menu that appears, tap Freeze or Unfreeze.

There's no View menu involved on Android. The option sits in the menu that pops up when you touch and hold a row number or column letter.

Freezing is not hiding

The most common mix-up is reaching for the wrong tool. Freezing keeps rows visible while you scroll. Hiding takes rows out of view entirely. If your header row has vanished, it may be hidden rather than frozen, and the freeze menu won't bring it back.

On a computer, per Google's help page:

  • Hide: click a row or column to highlight it, right-click, and choose Hide row or Hide column. An arrow appears where the hidden row or column was. To select several, Google's page says to hold the Command key (a Mac key) and click each row or column. The page doesn't name a key for Windows.
  • Show it again: click the arrow where the row number or column letter used to be.

On Android, touch and hold a row or column, then tap Hide Row or Hide column, according to Google's Android instructions.

So if a row seems missing, look for that arrow in the row numbers before you touch the freeze settings.

Group rows when you want to collapse sections

Grouping sits between freezing and hiding. It lets you fold away a block of rows and open it again with one click, which suits monthly breakdowns or detail rows under a total.

On a computer, Google's steps are:

  1. Select the rows or columns.
  2. Click View, then Group.
  3. Choose Group rows or Group columns. The same menu has Ungroup rows and Ungroup columns to undo it.

Click the Plus (+) or Minus (−) next to the group to expand or collapse it.

On Android, highlight the rows or columns, touch and hold them, then tap More, then Group or Ungroup, per the Android help page.

Which one to use

You want to... Use
Keep a header row or label column on screen while scrolling Freeze
Remove rows or columns from view Hide
Fold sections away and reopen them with + or − Group

Limits Google doesn't spell out

Once your headers are pinned, a sheet is easier to clean up and fill in. Two related guides: how to remove duplicates in Google Sheets and how to create a drop-down list.

Common questions

How do I unfreeze rows in Google Sheets?

On a computer, select a row or column, click View > Freeze, then choose No rows or No columns. On Android, touch and hold a row or column and tap Unfreeze.

Can I freeze rows in the Google Sheets Android app?

Yes. Open the spreadsheet, touch and hold a row or column, and tap Freeze in the menu that appears.

What's the difference between freezing and hiding rows?

Freezing keeps rows on screen while you scroll. Hiding removes them from view and leaves an arrow where they were; click the arrow to show them again.

How do I group rows in Google Sheets?

Select the rows, click View > Group, then Group rows. Use the Plus (+) or Minus (−) next to the group to expand or collapse it.

Person working on a laptop with a spreadsheet outdoors
How-to

How to Create a Drop-Down List in Google Sheets (From a Range or List)

Add a dropdown in Google Sheets, pull options from a range, allow multiple selections, accept other values, and edit or delete it.

· 4 min

More in Cloud & Productivity Software