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 wantWhere to go
Freeze rows or columnsSelect a row or column, then click View > Freeze and choose how many rows or columns to freeze
Unfreeze rowsSelect a row, then click View > Freeze > No rows
Unfreeze columnsSelect a column, then click View > Freeze > No columns
Repeat frozen rows on paperFile > Print > Headers & footers > Repeat frozen rows

Freeze rows or columns on a computer

  1. Open the spreadsheet in Google Sheets.
  2. Select a row or column.
  3. Click View, then Freeze.
  4. 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.

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

  1. Select a row or column.
  2. Click View > Freeze.
  3. 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.

  1. Freeze the rows or columns first.
  2. Click File > Print.
  3. Open Headers & footers in the print menu.
  4. 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.

TaskSteps
Group rows or columnsSelect them, then View > Group > Group rows or Group columns
UngroupView > Group > Ungroup rows or Ungroup columns
Expand or collapse a groupClick the plus (+) or minus (-) next to the group
Hide a row or columnRight-click it and choose Hide row or Hide column
Show a hidden row or columnClick 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.

ActionWindows / Chrome OSMac
Select columnCtrl + SpaceCtrl + Space
Select rowShift + SpaceShift + Space
Group rows or columnsAlt + Shift + Right ArrowOption + Shift + Right Arrow
Ungroup rows or columnsAlt + Shift + Left ArrowOption + Shift + Left Arrow
Hide rowCtrl + Alt + 9Cmd + Option + 9
Unhide rowCtrl + Shift + 9Cmd + Shift + 9
Hide columnCtrl + Alt + 0Cmd + Option + 0
Unhide columnCtrl + Shift + 0Cmd + 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.

TaskSteps
Insert rows, columns or cellsRight-click the selection, then choose Insert
Delete, clear or hide a row or columnRight-click the row number or column letter, then choose Delete, Clear or Hide
Move a row or columnSelect the row number or column letter, then drag it to a new location
Start a new line inside a cellPress Ctrl + Enter on Windows or Cmd + Enter on a Mac
Add another tabClick 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,.

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.

Leave a Reply

Your email address will not be published. Required fields are marked *