Google Sheets Freeze Rows Not Working? Fix the View

If frozen rows in Google Sheets keep scrolling away, open the correct sheet tab and choose View > Freeze > 1 row, 2 rows, or Up to current row. Then test by scrolling within the spreadsheet grid; if it still looks wrong, check whether you froze the intended rows, whether extra rows are frozen, and whether you have permission to change the sheet.

What freezing rows does in Google Sheets

Freezing keeps selected rows visible at the top of the spreadsheet while you scroll down through other rows. It is useful for headings such as Date, Customer, and Amount, because the labels remain in view beside the records they describe. Frozen rows are still part of the sheet: you can edit their cells, and freezing does not protect them from changes.

Freeze is different from hiding a row, applying a filter, or pinning a header in a web page. It changes the sheet’s scrolling layout; it does not move the row, make a copy, or keep a row visible in every context. For example, freezing row 1 does not make row 1 appear beside a record when you open a separate sheet tab. Each tab has its own row and column layout.

Google Sheets can freeze consecutive rows starting at row 1. To keep row 5 fixed, you must also freeze rows 1 through 4. You cannot freeze row 5 alone while allowing rows 1 through 4 to scroll normally. Rows and columns can be frozen at the same time, which is helpful when a table needs both a persistent header and identifying labels in its first column.

Try this quick repair first

In Google Sheets in a web browser, use the menu rather than relying on a drag handle that may be difficult to see. First click the tab at the bottom that contains the table, then use these steps:

Click a cell in the sheet so the spreadsheet grid is active.
Choose View > Freeze.
Choose 1 row for a single header, 2 rows for a two-line header, or Up to current row to keep all rows above and including the selected row visible.
Scroll down within the grid and confirm that the intended rows remain at the top.

If the wrong number of rows stays visible, return to View > Freeze and choose the desired option again. To remove frozen rows completely, choose View > Freeze > No rows. This does not delete data; it only returns those rows to the normal scrolling area. If you also froze columns, adjust the column setting separately in the same Freeze menu.

After changing the setting, allow the sheet to save before closing it. Google Sheets normally saves changes automatically when you are online, but a connection problem can delay saving. Look for a saving indicator or any offline warning, then reload only after the sheet has finished saving. If the change disappears after reopening, check connectivity and confirm that you edited the intended file.

Check that you are scrolling the sheet, not the page

A common source of confusion is moving the browser page instead of moving the spreadsheet’s rows. The browser page may scroll around the Sheets interface, while the sheet has its own grid and scrollbars. If the grid itself has not moved, the frozen row may appear stationary simply because none of the sheet’s rows have scrolled underneath it yet.

Click inside the grid and use its vertical scrollbar, or scroll while the pointer is over the grid. Move far enough down to pass the first unfrozen row. For example, if rows 1 and 2 are frozen, scroll until row 3 and later have moved. The frozen rows should remain at the top of the grid while the rest of the sheet moves.

Also check for a horizontal scrollbar or a narrow browser window that makes the grid appear crowded. Frozen rows stay at the top during vertical scrolling; they do not stay beside a column during horizontal scrolling. Frozen columns handle that separate situation. Browser zoom or a small window can make the boundary between frozen and scrolling cells less obvious, so expanding the window can help you inspect the result.

Look for the wrong tab, row count, or freeze boundary

Many workbooks contain several tabs, and a freeze setting on one tab does not automatically set it on the others. If the change seems to have no effect, check the tab name at the bottom before changing anything again. A similarly named tab, such as Data Copy or Archive, can be easy to mistake for the working sheet.

Next, check how many rows are frozen. If you chose Up to current row while a cell in row 8 was selected, rows 1 through 8 may stay visible. That can leave only a small area for the scrolling data, making it seem as if the sheet is stuck. Choose 1 row or 2 rows if those are the only header rows you need.

Look for the horizontal divider between frozen rows and the scrolling part of the sheet. It may be subtle, especially at a high zoom level or in a short window. If the divider is below the header, more rows are frozen than you may have intended. The Freeze menu is the clearest way to reset the count; after choosing No rows, set the intended number again.

Why freezing can seem ineffective

Several conditions can make the feature appear broken even when the setting is active:

You have not scrolled far enough. The first unfrozen row may not have moved out of view yet. Scroll down within the grid to test.
You froze a different tab. Each sheet tab has its own layout settings, so repeat the change on the tab you are viewing.
Too many rows are frozen. A large frozen area can occupy most of the window and hide the visual evidence that scrolling is happening.
The wrong area is moving. Scrolling the browser page is not the same as scrolling the sheet grid.
The file has not saved or refreshed. An offline connection or an unfinished save can make a change appear to vanish after reopening.
You cannot edit the file. If the file is view-only or you lack the necessary access, ask its owner or an editor to change the layout.

Hiding rows is another frequent misunderstanding. Hidden rows do not remain visible while you scroll; they are omitted from the displayed sequence until unhidden. Likewise, a filter can change which records appear but does not pin a header in place. If the header itself is missing rather than scrolling away, check whether its row is hidden or whether the sheet is filtered.

Reset and set the exact rows you need

If the layout has become confusing, a clean reset is often faster than trying to adjust an uncertain divider. On the affected tab, choose View > Freeze > No rows. Then set the desired number of rows from the same menu. For a table whose column labels are in row 1, choose 1 row. If the title is in row 1 and the actual labels are in row 2, choose 2 rows so both remain visible.

For a longer header, click a cell in the last row you want to keep fixed and select Up to current row. This includes every row above it, not just the selected row. Before using that option, verify the row number at the left edge of the grid. If the selected cell is in row 6, the result includes rows 1 through 6.

You can also adjust the freeze boundary by dragging the divider between the row numbers and the sheet area, when it is visible. Dragging is convenient for fine adjustments, but the menu is more predictable if the boundary is hard to locate. If you use the divider, watch the row numbers and release it at the intended boundary, then scroll to confirm the result.

Shared files, permissions, and browser differences

Freezing rows is a layout setting in the spreadsheet, not a personal note attached to a cell. In a shared file, changing the layout may affect what other collaborators see as they work in that tab. If you are editing a team sheet, consider whether a persistent header is helpful to everyone before changing it. If another editor changes the setting at the same time, the visible layout may change again.

If the Freeze menu is unavailable or you cannot make the change, check whether you have edit access. A viewer may need to request access or ask an owner or editor to make the adjustment. If you do have edit access but the sheet seems unresponsive, wait for pending changes to save, confirm that the browser is online, and reopen the file if needed. Avoid making repeated changes while a connection warning is visible, since it can be unclear which updates have reached the file.

These menu instructions are for Google Sheets in a web browser. The mobile app may arrange its controls differently, and small screens make frozen boundaries harder to inspect. If you are troubleshooting a layout carefully, use the browser version and check the correct sheet tab. Microsoft Excel has a separate interface: in Excel for Microsoft 365 on Windows, row freezing is under View > Freeze Panes, so Excel directions should not be substituted for the Google Sheets menu path.

Freeze rows versus other ways to keep context

Freezing is usually the right choice when you need the same header visible as you browse a long table. A filter is better when you need to narrow the displayed records, and sorting is useful for changing their order. Neither filtering nor sorting is a replacement for freezing: they affect the rows shown or their order, not whether the header remains fixed while scrolling.

For a small sheet, you may not need to freeze anything. For a wide table, freezing the first column as well as the header can help identify which record you are reading while moving horizontally. Avoid freezing many rows just to keep a note visible; a large frozen block reduces the space available for data. A concise header and one or two frozen rows are easier to navigate than a tall title area that takes up most of the screen.

Freezing also does not lock cells against editing. If your goal is to prevent collaborators from changing headings or formulas, use the sheet’s protection controls instead. Protection and freeze settings solve different problems: one restricts edits, while the other changes what remains in view. A frozen header can still be edited by someone who has permission to edit those cells.

Frequently Asked Questions

Why do my frozen rows still scroll in Google Sheets?
Confirm that you are scrolling inside the grid, not the browser page, and that you are on the tab where you froze the rows. Then check View > Freeze and set the intended row count. Scroll past the first unfrozen row to test.

How do I freeze only row 2?
Google Sheets freezes consecutive rows from the top, so you cannot freeze row 2 by itself. Choose 2 rows to keep both rows 1 and 2 visible. If row 1 is not needed, consider reorganizing the header or hiding row 1, bearing in mind that hiding is not the same as freezing.

How do I unfreeze rows without deleting them?
On the relevant sheet tab, choose View > Freeze > No rows. The rows remain in the sheet with their contents intact; they simply scroll normally again. Use the same menu afterward if you want to freeze a different number.

Can I freeze rows and columns at the same time?
Yes. Google Sheets lets you set row and column freezes independently, so a header can remain visible vertically while an identifying column stays visible horizontally. Check both settings in View > Freeze if the layout seems to hold more of the screen than expected.

Does freezing a row protect it from edits?
No. Freezing only keeps the row in view while scrolling. To restrict changes, use protection settings and choose the appropriate access for the cells or sheet; collaborators with editing access may otherwise change a frozen header.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.