How to Freeze Rows and Columns in Google Sheets

Freezing rows in Google Sheets keeps selected rows visible while the rest of the spreadsheet scrolls. It is most useful for header rows, summary rows, date bands, owner labels, and any context a reviewer needs while scanning a large table.

Use freeze rows when the sheet has enough records that users lose the column meaning as soon as they scroll.

Freeze the header row

Step 1. Open the Google Sheet.

Step 2. Choose View -> Freeze.

Step 3. Select 1 row.

The top row now stays visible while you scroll down.

This is a basic quality-of-life fix for expense trackers, project trackers, employee schedules, and content calendars because the column labels remain visible during review.

Freeze multiple rows

If the sheet has a title row, a summary row, and then headers, freeze more than one row.

Choose View -> Freeze -> 2 rows, or select a row and choose View -> Freeze -> Up to row [number].

For example, if rows 1 and 2 contain a dashboard summary and row 3 contains table headers, you may want to freeze the first three rows so both context and labels stay visible.

Freeze columns too

Rows are not the only context that can disappear. If the first column contains task names, employee names, vendors, clients, or accounts, freeze that column as well.

Choose View -> Freeze -> 1 column.

That makes wide sheets easier to scan because users can scroll across dates, owners, amounts, or stages without losing the row identity.

Unfreeze rows or columns

Choose View → Freeze → No rows to unfreeze rows, or View → Freeze → No columns to unfreeze columns. If scrolling feels stuck, check both settings; a frozen first column can be easy to overlook in a wide sheet.

Repeat frozen headers when printing

Google Sheets can repeat frozen rows or columns on every printed page:

1. Freeze the headers first.
2. Choose File → Print.
3. Open Headers & footers.
4. Enable Repeat frozen rows or Repeat frozen columns.

That makes a multi-page expense tracker or employee schedule easier to read as a PDF or printout.

When not to freeze rows

Freezing too many rows can make the working area feel cramped, especially on laptops. Keep the frozen area small: usually one header row, sometimes a short summary plus headers.

Freezing is not protection. Use protected ranges when the goal is to prevent edits, and use FILTER when the goal is to show matching records.

Common freeze-row mistakes

Do this with AI

Freeze rows is simple, but it often comes after the harder cleanup: choosing the right headers and removing unnecessary top-of-sheet clutter.

"Clean up this tracker, keep the summary and headers visible while scrolling, and freeze the task name column too"

Griddy can restructure the top rows, preserve useful context, and make the frozen view match how the team actually reviews the sheet.

Review view-only settings in the spreadsheet itself because different spreadsheet apps can represent frozen panes differently.

Sources

• Google Docs Editors Help: Freeze, group, hide, or merge rows and columns
• Google Docs Editors Help: Repeat frozen rows or columns when printing