If you've ever scrolled down a large Google Sheets spreadsheet and lost track of which column is which, you know how frustrating it can be. Learning how to freeze rows in Google Sheets solves this instantly — frozen rows stay visible at the top of your screen no matter how far you scroll.
In this guide, you'll learn how to freeze rows, columns, or both in Google Sheets. Whether you're working with a 50-row budget tracker or a dataset with thousands of rows imported via SmoothSheet, freezing panes keeps your headers locked in place so you always know what you're looking at.
Key Takeaways:Freeze rows via View > Freeze to keep headers visible while scrollingYou can freeze up to any row or column number — not just the first oneFreezing works on both desktop and the Google Sheets mobile appFrozen panes don't affect printing, formulas, or data — only your view
How to Freeze Rows in Google Sheets
Freezing rows keeps the top portion of your spreadsheet visible while you scroll through the rest. This is most commonly used to lock header rows in place.
Freeze the First Row (Header Row)
- Open your spreadsheet in Google Sheets.
- Click View in the top menu bar.
- Hover over Freeze.
- Select 1 row.
You'll see a thick gray line appear below the first row. That line indicates everything above it is frozen. Now scroll down — your header row stays pinned at the top.
Freeze the First Two Rows
Some spreadsheets use two header rows (for example, a category row and a sub-category row). To freeze both:
- Go to View > Freeze.
- Select 2 rows.
Both rows are now locked in place while you scroll through your data.
Freeze Up to a Specific Row
Need to freeze more than two rows? Maybe rows 1 through 5 contain instructions, labels, or summary data you want visible at all times.
- Click on any cell in the row up to which you want to freeze. For example, click a cell in row 5.
- Go to View > Freeze.
- Select Up to row 5 (the option dynamically shows your current row number).
Everything from row 1 through row 5 is now frozen. This works for any row number — if you click on row 10 first, the menu will show "Up to row 10."
How to Freeze Columns in Google Sheets
Freezing columns works exactly the same way as freezing rows, but keeps the left side of your spreadsheet visible as you scroll right. This is useful when column A contains names, IDs, or labels that give context to the data in other columns.
Freeze the First Column
- Click View in the top menu.
- Hover over Freeze.
- Select 1 column.
A thick gray border appears to the right of column A. Scroll horizontally and you'll see column A stays locked.
Freeze the First Two Columns
- Go to View > Freeze.
- Select 2 columns.
Freeze Up to a Specific Column
- Click any cell in the column up to which you want to freeze (e.g., column D).
- Go to View > Freeze.
- Select Up to column D.
Columns A through D are now frozen. Just like with rows, the menu dynamically adjusts based on the column your cursor is in.
How to Freeze Both Rows and Columns at the Same Time
You're not limited to freezing only rows or only columns — you can combine them. This is especially useful for wide spreadsheets where you need both the header row and an identifier column visible.
To freeze row 1 and column A simultaneously:
- Go to View > Freeze > 1 row.
- Then go to View > Freeze > 1 column.
Now your header row stays visible as you scroll down, and your first column stays visible as you scroll right. You can mix and match any combination — for example, freeze 3 rows and 2 columns if your layout requires it.
How to Unfreeze Rows and Columns
Removing frozen panes is just as straightforward:
- Click View in the menu bar.
- Hover over Freeze.
- Select No rows to unfreeze rows, or No columns to unfreeze columns.
The thick gray line will disappear and your spreadsheet returns to normal scrolling behavior. If you froze both rows and columns, you'll need to unfreeze each one separately.
Freeze vs Hide: What's the Difference?
Freezing and hiding rows or columns are completely different features, and confusing the two is a common mistake.
| Feature | Freeze | Hide |
|---|---|---|
| What it does | Locks rows/columns on screen while you scroll | Removes rows/columns from view entirely |
| Data still exists? | Yes — fully visible | Yes — but not visible until unhidden |
| Affects formulas? | No | No (hidden cells are still calculated) |
| Affects printing? | No (frozen rows print normally) | Yes (hidden rows won't print) |
| Use case | Keep headers visible during navigation | Temporarily remove irrelevant data from view |
Key point: If you want headers to stay visible while scrolling, use freeze. If you want to declutter your view by removing certain rows or columns, use hide. You can apply conditional formatting and data validation on frozen cells just like any other cell — freezing changes nothing about how the data works.
Freezing Tips for Large Datasets
Freezing panes becomes essential once your spreadsheet grows beyond what fits on a single screen. Here are practical tips for working with large datasets:
Always Freeze Your Header Row First
Before you start scrolling through data, freeze row 1. It's a simple habit that prevents confusion. If you're importing thousands of rows from a CSV or Excel file — especially using a tool like SmoothSheet to handle large files without browser crashes — the first thing you should do after import is freeze the header row.
Use the Gray Drag Handle
There's a visual shortcut many users don't know about. Look at the top-left corner of your spreadsheet — right where the row numbers and column letters meet. You'll see a small thick gray bar along the top edge and the left edge. You can click and drag these bars to freeze rows or columns without using the menu at all.
- Drag the top bar downward to freeze rows.
- Drag the left bar rightward to freeze columns.
This is the fastest way to freeze panes, and dragging it back to the corner unfreezes them.
Check Frozen Panes Before Using Pivot Tables
If you're building a pivot table from your data, make sure your freeze settings don't interfere with your data range selection. Frozen rows aren't excluded from formulas or pivot ranges, but they can sometimes cause visual confusion when selecting data.
Freezing Doesn't Fix Slow Spreadsheets
If your spreadsheet is sluggish because it contains hundreds of thousands of rows, freezing panes won't help with performance. Freezing is purely visual. For performance issues related to large datasets, check our Google Sheets Limits Calculator to see if your data is pushing against the 10 million cell limit.
Frequently Asked Questions
Can you freeze rows in the Google Sheets mobile app?
Yes. In the Google Sheets app on Android or iOS, tap on the row number to select the entire row you want to freeze. Then tap the three-dot menu and choose Freeze row. To freeze columns, tap the column letter instead. The process is slightly different from desktop but the functionality is the same.
Why can't I freeze rows in Google Sheets?
If the Freeze option is grayed out, you likely have view-only or comment-only access to the spreadsheet. Freezing requires at least editor access. Additionally, if you're inside a filter view, some menu options may behave differently. Exit the filter view and try again.
Do frozen rows appear when I print my spreadsheet?
Frozen rows print normally as part of the spreadsheet — they don't repeat on every printed page. If you want headers to repeat on each printed page, go to File > Print > Headers & footers and check Repeat frozen rows. This setting is separate from the freeze feature itself.
Is there a keyboard shortcut to freeze rows in Google Sheets?
Google Sheets doesn't have a dedicated keyboard shortcut for freezing panes. However, you can navigate the menu quickly using keyboard access: press Alt + V (or Option + V on Mac) to open the View menu, then press F for Freeze, then select your option. For frequent use, the gray drag handle at the top-left corner of the sheet is faster than any shortcut.
Conclusion
Freezing rows and columns in Google Sheets is one of the simplest features to use, and one of the most valuable for everyday spreadsheet work. Whether you're reviewing a small budget or navigating a massive dataset, keeping your headers visible eliminates guesswork and saves time.
Use View > Freeze to lock any number of rows or columns, combine both for wide spreadsheets, and remember the drag handle shortcut for quick adjustments. Your future self, scrolling through row 5,000, will thank you.