How do you freeze rows and columns in Google Sheets?
Freezing locks the top rows or left columns in place while the rest of the sheet scrolls. View > Freeze lets you pin one row, two rows, or up to the current selection. Frozen panes keep headers and row labels visible on long trackers and financial models.
When to use it
Freeze when a sheet has more than twenty data rows or many columns: inventory lists, budget models, CRM exports, and QA tables where column A holds names you must always see.
When to skip it
Skip freezing on tiny one-screen tabs or presentation slides sized for export only. Over-freezing half the sheet leaves too little scroll area on small laptops.
How it works
-
1
Click the row below your header or the column right of your labels, then View > Freeze > Up to current row or column.
-
2
Use Freeze > 1 row or 2 rows for standard single-header tables without clicking a cell first.
-
3
Drag the thick gray divider line at the edge of the frozen pane to adjust how many rows or columns stay fixed.
-
4
Unfreeze with View > Freeze > No rows and No columns when the layout changes.
-
5
Pair freeze with filter views so headers stay put while editors filter long lists.
-
6
Remember frozen panes are per sheet; duplicate tabs need freeze set again if you want the same behavior.
Examples in Google Sheets
Two-row header model
Freeze two rows so month labels on row 2 and metric names on row 3 remain visible while scrolling through twelve months of scenarios.
ID column on wide export
Freeze column A with customer names while scrolling right through thirty metric columns from a BI export.
Dashboard with controls on top
Freeze rows 1 through 4 holding title, slicer instructions, and KPI labels above a long detail grid.
Better Sheets resources
Common mistakes
-
Freezing too many rows on a 13-inch screen so barely any data rows remain in view.
-
Forgetting freeze after inserting rows above the header, which pushes labels out of the frozen zone.
-
Expecting freeze to apply across all tabs in the workbook automatically.
-
Merging cells in the header row then freezing, which confuses print layout and filter ranges.
-
Hiding row 1 while it is frozen without telling collaborators where filters live.
Frequently asked questions
- How do I freeze the top row?
- View > Freeze > 1 row, or click row 2 and choose Up to current row.
- Freeze row and column together?
- Yes. Freeze rows first, then freeze columns, or freeze up to the cell at the intersection you need.
- Freeze vs split pane?
- Google Sheets uses freeze panes. There is no separate split window like some desktop apps.
- Does freeze affect printing?
- Frozen panes are a view setting. Set print area and repeat rows on each page separately for PDF export.
- Freeze on mobile?
- Mobile scrolling ignores desktop freeze in practice. Review wide sheets on desktop for real work.
- Can viewers change freeze?
- Freeze is per user session on view-only files in many cases. Editors set the default on shared edit files.
- Freeze and hidden rows?
- Hidden rows inside the frozen block stay hidden but still occupy freeze space. Plan header height carefully.
- Unfreeze everything?
- View > Freeze > No rows and No columns clears both dimensions.
Related Tutorials
Watch how Freeze rows and columns works
Create an Internal Google Sheets Add-on
Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script
Related blog posts
Guides that explain Freeze rows and columns in more depth.
Related terms
cell formatting
Cell formatting controls how values display without necessarily changing the stored value underneath. Currency, percent, date, and plain text formats keep reports readable and prevent Sheets from auto-converting IDs into dates. Good formatting is the difference between a sheet leadership trusts and one they argue with.
Read guide →dashboards
A dashboard is a single view that answers "how are we doing?" without hunting across tabs. In Google Sheets, it is usually a summary tab with big numbers, charts, and conditional formatting fed by QUERY, pivot tables, or IMPORTRANGE from raw data you keep elsewhere.
Read guide →reports from Google Sheets
A report turns raw data into a readable snapshot: summary metrics, charts, and tables formatted for an audience. Separate source data tabs from a Report tab that uses QUERY, pivot tables, or SUMIF so you refresh inputs without rebuilding layout every week.
Read guide →Named range
A named range gives a block of cells a readable label like Revenue or ValidStatuses instead of only B2:B500. Define names from Data > Named ranges. Formulas, charts, pivot tables, and validation rules can reference the name, which makes models easier to audit and safer when rows shift inside the named block.
Read guide →Done reading about Freeze rows and columns?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.