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:
- Open the spreadsheet in Google Sheets.
- Select a row or column you want to freeze.
- At the top, click View, then Freeze.
- 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
- Select a row or column.
- Click View, then Freeze.
- 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:
- Open the spreadsheet in the Google Sheets app.
- Touch and hold a row or column.
- 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:
- Select the rows or columns.
- Click View, then Group.
- 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.