Stop Stuck Panes: How to Unfreeze Rows in Google Sheets in 4 Easy Steps
Learning how to unfreeze rows in Google Sheets takes two clicks, and it frees a sheet that feels stuck. On a computer, click View, then Freeze, then No rows, and the frozen rows start scrolling with the rest of the sheet. The thick gray line under the frozen rows disappears, and the whole sheet moves as one again. This guide shows four easy steps, the mobile path, and the mistakes that keep panes stuck.
A frozen row helps while you work down a long list, and it gets in the way when the job changes. Knowing how to unfreeze rows in Google Sheets is part of that normal workflow, not a fix for a mistake. A header frozen for data entry eats screen space during a print, and a frozen column blocks a side-by-side check of two far-apart columns. Unfreezing is not a failure, because it is a normal part of working with a sheet. Freeze when the header helps, unfreeze when it does not, and freeze again when the next job needs it.
[SNIPPET TARGET] To unfreeze rows in Google Sheets on a computer, click View, then Freeze, then No rows. To unfreeze columns, click View, then Freeze, then No columns. On mobile, tap the frozen row number and tap Unfreeze.
ANSWER BOX 1
To unfreeze rows in Google Sheets on a computer, click View in the menu bar, then point to Freeze, then click No rows. The thick gray line under the frozen rows disappears, and the whole sheet scrolls as one again. If columns are frozen too, repeat the steps and click No columns, because rows and columns unfreeze separately.
ANSWER BOX 2
To unfreeze rows in the Google Sheets mobile app, tap the row number of a frozen row. On Android, touch and hold the row number, then tap Unfreeze in the menu. On iPhone and iPad, tap the row number, tap the right arrow in the menu, then tap Unfreeze. All frozen panes clear at once on mobile.
KEY TAKEAWAYS
- To unfreeze rows in Google Sheets on desktop, click View, then Freeze, then No rows, and the gray divider line disappears.
- Rows and columns unfreeze separately, so repeat the steps with No columns when a column is frozen too.
- Drag the thick gray freeze line back to the top of the sheet to unfreeze by hand, with no menu at all.
- On mobile, tap the frozen row number and tap Unfreeze, and all frozen panes clear at once.
- Unfreezing never deletes or moves data, and you can freeze the same rows again in seconds.
Contents
- What does unfreezing do?
- Unfreeze in 4 easy steps
- Unfreeze on Android and iPhone
- How to tell which rows are frozen
- When to unfreeze and when to keep the freeze
- 5 mistakes that keep panes stuck
- FAQ
- Final Word
What Does Unfreezing Do in Google Sheets?
Unfreezing removes the pin that holds rows at the top of the screen, so they scroll with the rest of the sheet again. That pin is all that changes when you learn how to unfreeze rows in Google Sheets: the data stays put. The rows themselves do not move, change, or vanish, because unfreezing changes only the view. A header row that was pinned at the top scrolls off the screen like any other row, and the sheet behaves like a normal sheet with no frozen zone. The thick gray line that marked the frozen edge disappears at the same moment.
Unfreezing is safe, and it is also reversible in seconds. Learning how to unfreeze rows in Google Sheets is safe to try, because freezing the rows again takes three clicks. If you unfreeze and then miss the header, freeze it again with View, then Freeze, then 1 row. No data is lost in either direction, and no formula breaks, because freezing and unfreezing touch only the scrolling behavior. That safety makes it fine to unfreeze whenever the freeze gets in the way.
A frozen header pairs with a filter, because the header stays visible while the filtered rows change. Our guide on how to filter data in Google Sheets shows filters and filter views. If you unfreeze to print or to compare columns, remember to freeze the header again before you filter, so the filter buttons stay in view.
QUICK ANSWER: Does unfreezing delete my data?
No, unfreezing never deletes, moves, or changes any cell. It only removes the pin that holds rows at the top of the screen, so they scroll normally again. Your data, your formulas, and your formatting all stay exactly where they were.
How to Unfreeze Rows in Google Sheets in 4 Easy Steps

These four steps cover every way to unfreeze, from the menu to the drag handle to the mobile app. The menu method is the most reliable, so start there when in doubt. Learning how to unfreeze rows in Google Sheets starts with that menu method.
- Unfreeze rows with the View menu. Click any cell in the sheet, then click View in the menu bar at the top. Point to Freeze in the menu, then click No rows in the submenu. The gray line under the frozen rows vanishes at once, and the rows scroll with the rest of the sheet.
- Unfreeze columns the same way. Click View again, point to Freeze, and click No columns. Rows and columns unfreeze separately, so a sheet with both frozen needs both steps. If you only clear the rows, the frozen column stays pinned on the left.
- Drag the gray freeze line back to the top. Find the thick gray line under the last frozen row, point at it until the cursor turns into a hand, then drag it straight up above row 1. Release the mouse, and the rows unfreeze. Drag the vertical gray line to the left past column A to unfreeze columns the same way.
- Unfreeze on mobile with a tap. Open the sheet in the Google Sheets app and tap the row number of a frozen row. On Android, touch and hold the row number, then tap Unfreeze in the menu. On iPhone and iPad, tap the row number, tap the right arrow, then tap Unfreeze. All frozen panes clear at once on mobile.
Bonus: Unfreeze with Apps Script
Apps Script can unfreeze rows and columns with two lines of code, which suits a sheet you reset often. Open Extensions, then Apps Script, and run a function that calls setFrozenRows(0) and setFrozenColumns(0) on the active sheet. A zero in both calls removes every freeze at once.
How to Unfreeze Rows in Google Sheets on Android and iPhone
The Sheets app has no View menu, so unfreezing works from the row number itself. That row-number tap is how to unfreeze rows in Google Sheets on a phone, and it clears every frozen pane at once. On Android, open the spreadsheet in the Google Sheets app, then touch and hold the row number of a frozen row. A menu appears, and it offers Unfreeze, so tap it. Every frozen pane clears at once, and the whole sheet scrolls as one again.
On iPhone and iPad, the gesture is a tap instead of a hold. Open the spreadsheet in the Sheets app and tap the row number of a frozen row. A menu appears, so tap the right arrow until you see Unfreeze, then tap it. The frozen rows release, and the thick gray line disappears from the screen. The change saves in the file, so the rows are unfrozen on desktop too.
How to Tell Which Rows Are Frozen
A frozen sheet shows a thick gray line under the last frozen row, and that line is darker than the normal gridlines. Spotting that line is the first step in learning how to unfreeze rows in Google Sheets, because you cannot clear a freeze you cannot see. If row 1 is frozen, the line sits between row 1 and row 2. If three rows are frozen, the line sits under row 3. Scroll down slowly, and the rows above the line stay put while the rows below it move. That stillness is the clearest sign of a freeze.
A frozen column shows the same kind of line, but vertical, to the right of the last frozen column. If column A is frozen, a thick gray line runs down the right edge of column A. Scroll right, and column A stays on screen while the other columns move. A sheet can show both lines at once, one horizontal and one vertical, when rows and columns are frozen together.
When to Unfreeze and When to Keep the Freeze
Unfreeze when the frozen zone costs more screen than it saves. A two-row header on a phone leaves little room for data, so unfreeze it before a long mobile check. A frozen column blocks a side-by-side look at two far-apart columns, so unfreeze it before the comparison. A printout with a frozen header can also look odd, so unfreeze before you print, or use the Repeat frozen rows print setting instead.
Keep the freeze when the header guides your work. Data entry down a long list needs the labels in view, so keep row 1 frozen while you type. A shared report needs the header visible for every reader, so keep the freeze and tell the team it is there. A tall table with many columns needs both the header and the label column frozen, so keep both while the team works through it.
When the freeze goes back on, the header is easy to pin again. Our guide on how to freeze rows in Google Sheets shows the five ways to freeze, on desktop and mobile. Freeze it again after the print or the comparison, so the next person who opens the sheet sees the labels at once.
5 Mistakes That Keep Panes Stuck
These five mistakes cause most unfreezing problems, and each one is easy to avoid once you know it. Most of them come from forgetting that rows and columns unfreeze separately, so learning how to unfreeze rows in Google Sheets means clearing both. Read the list before you fight with a stuck pane again.
- Unfreezing rows but forgetting the columns. Rows and columns unfreeze separately, so a frozen column stays pinned after you click No rows. Repeat the steps with No columns to clear both.
- Trying to unfreeze a view-only file. A view-only file blocks layout changes, so the Freeze menu offers nothing to click. Ask the owner for edit access, or make your own copy of the sheet.
- Dragging the wrong gray line. A normal gridline looks gray too, but only the thick freeze line moves when you drag it. Look for the line that is clearly thicker and darker than the rest.
- Unfreezing on the wrong tab. Each tab in a spreadsheet keeps its own freeze, so clearing one tab leaves the others frozen. Open the tab that looks stuck, and unfreeze that tab.
- Forgetting the freeze is saved in the file. An unfreeze you set changes the view for everyone, so a teammate may lose the header they rely on. Tell the team, or freeze the rows again after your task.
How to Unfreeze Rows in Google Sheets FAQ
How do I unfreeze rows in Google Sheets?
Click View, then Freeze, then No rows. The thick gray line under the frozen rows disappears, and the rows scroll with the rest of the sheet.
How do I unfreeze columns in Google Sheets?
Click View, then Freeze, then No columns. The vertical gray line beside the frozen column disappears, and the column scrolls with the rest of the sheet.
How do I unfreeze rows in the Google Sheets app?
On Android, touch and hold the row number of a frozen row, then tap Unfreeze in the menu. On iPhone and iPad, tap the row number, tap the right arrow, then tap Unfreeze. All frozen panes clear at once on mobile.
Why won’t my rows unfreeze in Google Sheets?
The most common cause is view-only access, because a view-only file blocks layout changes. Ask the owner for edit access, or make a copy of the sheet.
How do I unfreeze only one row in Google Sheets?
You cannot unfreeze a single row, because freezing always starts from row 1 and covers every row down to the last frozen one. Click View, then Freeze, then No rows to clear them all.
Can I unfreeze rows with a keyboard shortcut?
No, Google Sheets has no dedicated keyboard shortcut for unfreezing rows. Open the View menu with Alt and V in Chrome on Windows, or Ctrl, Option, and V on a Mac, then use the arrow keys to reach Freeze and No rows.
How do I unfreeze rows and columns at the same time?
There is no single option that clears both at once on desktop. Click View, then Freeze, then No rows, then repeat the steps with No columns.
Will unfreezing delete my data?
No, unfreezing never deletes, moves, or changes any cell. It only removes the pin that holds rows at the top, so they scroll normally again. Your data, formulas, and formatting all stay exactly where they were.
How do I know which rows are frozen?
Look for a thick gray line under the last frozen row, darker than the normal gridlines. Scroll down, and the rows above the line stay put while the rows below move.
How do I freeze rows again after unfreezing?
Click View, then Freeze, then choose 1 row, 2 rows, or Up to current row. Our full guide is at how to freeze rows in Google Sheets. Freezing again takes three clicks, and the header stays visible while you scroll.
Can I sort a sheet with frozen rows?
Yes, a frozen header helps sorting, because the labels stay visible while you pick the sort column. Our guide on how to sort data in Google Sheets shows the safe seven-step sort. Freeze the header first, then sort the table.
How do I unfreeze rows with Apps Script?
Open Extensions, then Apps Script, and run a function that calls setFrozenRows(0) and setFrozenColumns(0) on the active sheet. A zero in both calls removes every freeze at once. Save the script and run it whenever the sheet needs a clean view.
Final Word
Unfreezing is a two-click job, and it frees a sheet that feels stuck without touching a single cell. The View menu clears rows and columns, the drag handle clears them by hand, and the mobile app clears them with a tap. Learning how to unfreeze rows in Google Sheets is mostly remembering those three paths. Check for both the horizontal and the vertical gray line before you call the job done, and tell the team when you clear a freeze they rely on.
When the header needs to stay visible again, freeze it back in three clicks. Our guide on how to freeze rows in Google Sheets shows the five ways to freeze, on desktop and mobile. Freeze when the header helps, unfreeze when it does not, and the sheet will always show you what you need.
Read more about Google Sheets on Wikipedia: https://en.wikipedia.org/wiki/Google_Sheets
