How To Freeze Rows And Columns In Google Sheets (2026)
When you scroll down a long Google Sheet, the header row disappears and you lose track of which column is which.
Freezing pins chosen rows or columns in place so they stay visible while the rest of the sheet scrolls.
The steps below follow Google’s Docs Editors Help pages for the computer version of Sheets, including how to unfreeze and how to print frozen rows on every page.
Quick answer: freeze and unfreeze in Google Sheets
| What you want | Where to go |
|---|---|
| Freeze rows or columns | Select a row or column, then click View > Freeze and choose how many rows or columns to freeze |
| Unfreeze rows | Select a row, then click View > Freeze > No rows |
| Unfreeze columns | Select a column, then click View > Freeze > No columns |
| Repeat frozen rows on paper | File > Print > Headers & footers > Repeat frozen rows |
Freeze rows or columns on a computer
- Open the spreadsheet in Google Sheets.
- Select a row or column.
- Click View, then Freeze.
- Choose how many rows or columns you want to freeze from the list.
Google’s page describes this as pinning data so it stays visible while you scroll.
The frozen rows sit above the scrolling area and the frozen columns sit on its left edge.
Keep the header row visible
The most common reason to freeze is a table with labels in row 1.
Select row 1, click View > Freeze, and choose the option for one row.
If your labels sit lower down, choose a larger number in the same menu so that every row above your data stays in place.
The same menu works for the first column when row labels such as names or product codes sit in column A.
Unfreeze rows or columns
- Select a row or column.
- Click View > Freeze.
- Choose No rows to release frozen rows, or No columns to release frozen columns.
Rows and columns are separate settings, so unfreezing one does not unfreeze the other.
Repeat frozen rows on every printed page
A frozen row stays in place on screen, but a printout only repeats it if you ask for that in the print settings.
- Freeze the rows or columns first.
- Click File > Print.
- Open Headers & footers in the print menu.
- Select Repeat frozen rows, Repeat frozen columns, or both.
Google says these then repeat on every printed page.
To print only part of the file, the same menu lets you pick Current sheet, Workbook or Selected cells.
Group or hide rows instead of freezing
Freezing is not the only way to manage a long sheet, and Google documents two related tools on the same help page.
| Task | Steps |
|---|---|
| Group rows or columns | Select them, then View > Group > Group rows or Group columns |
| Ungroup | View > Group > Ungroup rows or Ungroup columns |
| Expand or collapse a group | Click the plus (+) or minus (-) next to the group |
| Hide a row or column | Right-click it and choose Hide row or Hide column |
| Show a hidden row or column | Click the arrow that appears where it was hidden |
Google says grouping helps you organize and summarize related data.
Merge cells from the same menu family
Google’s freeze page also covers merging, which is a separate feature from freezing.
Select the rows, columns or cells, click Format > Merge cells, and then choose how to merge them.
The page does not list any limits on merging or its effect on freezing, so test the layout on a copy of important data first.
Keyboard shortcuts for rows and columns
Google’s shortcut list for Sheets does not include a shortcut for freezing, so freezing is a menu action.
It does list shortcuts for selecting and grouping rows and columns, which speed up the selection step.
| Action | Windows / Chrome OS | Mac |
|---|---|---|
| Select column | Ctrl + Space | Ctrl + Space |
| Select row | Shift + Space | Shift + Space |
| Group rows or columns | Alt + Shift + Right Arrow | Option + Shift + Right Arrow |
| Ungroup rows or columns | Alt + Shift + Left Arrow | Option + Shift + Left Arrow |
| Hide row | Ctrl + Alt + 9 | Cmd + Option + 9 |
| Unhide row | Ctrl + Shift + 9 | Cmd + Shift + 9 |
| Hide column | Ctrl + Alt + 0 | Cmd + Option + 0 |
| Unhide column | Ctrl + Shift + 0 | Cmd + Shift + 0 |
Other row and column tasks on Google’s beginner page
Google’s Learning Center page for new spreadsheet users lists the everyday row and column actions that sit alongside freezing.
| Task | Steps |
|---|---|
| Insert rows, columns or cells | Right-click the selection, then choose Insert |
| Delete, clear or hide a row or column | Right-click the row number or column letter, then choose Delete, Clear or Hide |
| Move a row or column | Select the row number or column letter, then drag it to a new location |
| Start a new line inside a cell | Press Ctrl + Enter on Windows or Cmd + Enter on a Mac |
| Add another tab | Click Add sheet at the bottom of the spreadsheet |
Freezing in Google Sheets versus Excel
Excel uses a selected cell to decide what to freeze, while Sheets asks you to pick a row or column and then choose a count from the View > Freeze menu.
If you also work in Excel, see our guide to freezing rows and columns in Excel.
Google’s own best-practices page for using both programs lists converting an Excel file to Sheets as one of four ways to work with Excel files,.
Related Google Sheets guides
If other people edit the sheet and you want to stop them changing your header, see how to lock cells or protect a sheet in Google Sheets.
If someone overwrites your data, restoring an earlier version in Google Docs explains the version history tool that Sheets shares.
If a shared file will not open for you, read fixing the Google Drive You need access error.
Sources
Google Docs Editors Help: Freeze, group, hide or merge rows and columns.
Google Docs Editors Help: Print from Google Sheets.
Google Docs Editors Help: Keyboard shortcuts for Google Sheets.
Google Workspace Learning Center: Create your first spreadsheet.