How to Freeze Rows in Google Sheets on Any Device
Keep spreadsheet headers visible while you scroll. Learn how to freeze and unfreeze rows in Google Sheets on desktop, Android, iPhone and iPad.
Photo by Carlos Muza on Unsplash
Long spreadsheets become difficult to follow when the header disappears as soon as you scroll. Freezing a row keeps important labels visible while the rest of the sheet moves, so you can match every value to the correct column without repeatedly scrolling back to the top.
This guide explains how to freeze rows in Google Sheets on a computer, Android phone, iPhone, and iPad. You will also learn how to freeze multiple rows or columns, remove a freeze, repeat headings when printing, and solve common problems.
What freezing a row does in Google Sheets
A frozen row stays fixed at the top of the spreadsheet while you scroll through the rows below it. It is especially useful for column headings such as Name, Date, Status, and Total.
Freezing changes only how you view and navigate the sheet. It does not protect the row from edits, lock its cells, or prevent collaborators from changing its contents. For those controls, you need Google Sheets’ protected ranges feature.
How to freeze the top row in Google Sheets on a computer
- Open the spreadsheet in Google Sheets.
- Choose View from the menu bar.
- Point to Freeze.
- Select 1 row.
A darker horizontal line appears below row 1. When you scroll down, the first row remains visible.
How to freeze multiple rows
If your sheet has a title in row 1 and headings in row 2, freezing only the first row is not enough. Google Sheets lets you keep several rows visible.
Freeze the first two rows
- Choose View > Freeze.
- Select 2 rows.
Freeze three or more rows
- Click the row number of the last row you want to keep visible. For example, click row 4 to freeze rows 1 through 4.
- Choose View > Freeze.
- Select Up to row 4, or the equivalent option shown for your selected row.
Google Sheets freezes every row from the top of the sheet through the selected row. It cannot freeze a middle row independently while allowing the rows above it to scroll.
How to freeze columns as well as rows
You can keep a header row and an identifying column visible at the same time. This is helpful when a wide sheet has names or item numbers in column A.
- Freeze the required rows using View > Freeze.
- Return to View > Freeze.
- Choose 1 column, 2 columns, or Up to column followed by the selected column letter.
The frozen row and column remain on screen as you scroll both vertically and horizontally.
How to freeze rows in the Google Sheets Android app
- Open the spreadsheet in the Google Sheets app.
- Touch and hold the number of the row you want to freeze.
- In the menu that appears, tap Freeze.
To freeze several rows, select through the last row you want included before choosing Freeze. The exact menu layout can vary slightly with the app version and screen size.
How to freeze rows in Google Sheets on iPhone or iPad
- Open the sheet in the Google Sheets app.
- Tap the row number.
- Tap the right arrow in the action menu if Freeze is not immediately visible.
- Tap Freeze.
Selecting a later row freezes it together with every row above it. This works well when your spreadsheet uses more than one header row.
How to unfreeze rows or columns
On a computer
- Choose View > Freeze.
- Select No rows to remove frozen rows.
- Select No columns if you also want to remove frozen columns.
On Android, iPhone, or iPad
Select the frozen row or column again, open its action menu, and choose Unfreeze. You may need to tap an arrow or the three-dot menu to see the option.
How to repeat frozen rows when printing
A frozen row stays visible on screen, but it does not automatically appear at the top of every printed page. Google Sheets provides a separate print setting for that.
- Freeze the header row or rows you want to repeat.
- On a computer, choose File > Print.
- Open Headers & footers.
- Enable Repeat frozen rows. If needed, also enable Repeat frozen columns.
- Check the preview before printing or saving as a PDF.
This setting makes multi-page reports much easier to read because each page retains its column labels.
Why freezing rows may not work
You selected the wrong row
The “Up to current row” option freezes the selected row and every row above it. Click the correct row number before opening the Freeze menu.
You are using a view-only sheet
People with view-only access may not be able to make changes that affect the spreadsheet’s saved layout. Ask the owner for edit access or create a copy if copying is permitted.
Merged cells cross the freeze boundary
A merged cell spanning both frozen and unfrozen areas can cause confusing behavior. Unmerge the cells, apply the freeze, and then reconsider whether the merge is necessary. Separate headings are usually easier to sort, filter, and read.
You confused filters with frozen rows
A filter changes which records appear or how they are ordered. A freeze keeps headings visible. The two features can be used together, but enabling a filter does not freeze its header row.
The divider is difficult to see
Scroll down a few rows and look for a heavier horizontal line beneath the frozen section. Browser zoom, display scaling, or a very small screen can make the divider subtle.
The mobile app menu looks different
Update the Google Sheets app, select the row number rather than an individual cell, and look for an arrow or overflow menu. Opening the sheet in a mobile browser may show fewer controls than the app.
Practical tips for cleaner spreadsheets
- Freeze only what provides context. Large frozen sections leave less room for the actual data, especially on phones.
- Keep headers short and specific. Clear labels reduce horizontal scrolling and make filters easier to understand.
- Use one consistent header area. Blank rows and decorative titles between headers and data can complicate sorting.
- Check the sheet on a small screen. Two frozen rows may work well on a monitor but take too much space on a phone.
- Use print preview. Screen freezes and printed repeated rows are related settings, but the final page breaks still need checking.
Frequently asked questions
Can I freeze a row that is not at the top?
No. Google Sheets freezes the selected row together with every row above it. You cannot keep row 10 fixed while rows 1 through 9 continue to scroll.
Can I freeze both rows and columns?
Yes. Apply a row freeze and a column freeze separately from the same View > Freeze menu. They work at the same time.
Does freezing a row stop other people from editing it?
No. Freezing is a navigation setting, not a security control. Use protected sheets and ranges if you need to restrict editing.
Will frozen rows appear on every printed page?
Only if you enable Repeat frozen rows in the print settings. Always review the print preview before printing or exporting.
Can collaborators have different frozen rows?
Freeze settings are part of the spreadsheet’s layout, so changing them can affect how collaborators see the file. If you need a personal working arrangement, consider using a separate copy when appropriate.
Conclusion
For most spreadsheets, freezing the first row is enough: choose View > Freeze > 1 row. When the header spans several rows, select the last header row and freeze up to it. On mobile, select the row number and use the Freeze command. The result is a sheet that stays understandable even when it contains hundreds or thousands of records.
Related Google productivity guides
Sources
- Google Docs Editors Help: Freeze, group, hide, or merge rows and columns
- Google Docs Editors Help: Print from Google Sheets
Featured image: Photo by Carlos Muza on Unsplash.