How to unfreeze rows in Google Sheets
Go to View → Freeze → No rows (or No columns) to unlock frozen panes. You can also drag the thick gray freeze handle back to the top-left corner. After unfreezing, the whole sheet scrolls together again.
Steps
-
1
Open View → Freeze.
-
2
Choose No rows and/or No columns.
-
3
Or drag the freeze bars back to the origin.
Related tutorials
These videos might help you go deeper on this topic.
Create an Internal Google Sheets Add-on
Related blog posts
Written guides that go deeper on this question.
Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
Related questions
How to freeze rows and columns in Google Sheets
Click View → Freeze and choose 1 column or 2 columns, or freeze up to the selected column. You can also drag the vertical freeze handle to the right of column A. Frozen columns stay visible while you scroll sideways through wide sheets.
Get the answer →How to unfreeze columns in Google Sheets
Go to View → Freeze → No rows (or No columns) to unlock frozen panes. You can also drag the thick gray freeze handle back to the top-left corner. After unfreezing, the whole sheet scrolls together again.
Get the answer →How to freeze rows in Google Sheets
Go to View → Freeze and choose 1 row or 2 rows, or pick Up to row N after selecting a row. You can also drag the freeze handle below the row numbers until the rows you want are locked. Frozen rows stay on screen while the rest of the sheet scrolls. Unfreeze anytime with View → Freeze → No rows.
Get the answer →How to freeze rows on Google Sheets
Open View → Freeze → 1 row (or 2 rows / Up to row …) to lock header rows while you scroll. You can also drag the horizontal freeze handle under the row numbers. Use this so labels stay on screen as you move through long lists.
Get the answer →How to freeze multiple rows in Google Sheets
Open View → Freeze → 1 row (or 2 rows / Up to row …) to lock header rows while you scroll. You can also drag the horizontal freeze handle under the row numbers. Use this so labels stay on screen as you move through long lists.
Get the answer →How to unfreeze cells in Google Sheets
Go to View → Freeze → No rows (or No columns) to unlock frozen panes. You can also drag the thick gray freeze handle back to the top-left corner. After unfreezing, the whole sheet scrolls together again.
Get the answer →Need more than a quick answer?
600+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.
Need one fix
Watch a free tutorial for the step-by-step version of any answer.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.