How to unfreeze a row 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
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 top row 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 freeze row 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 do you freeze a row 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 freeze a specific row 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 freeze row in google sheet
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 →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.