In Google Sheets how to freeze row
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.
Steps
-
1
Put headers in the top row(s).
-
2
Go to View → Freeze.
-
3
Choose 1 row, 2 rows, or Up to current row.
-
4
Clear later with View → Freeze → No rows.
Related tutorials
These videos might help you go deeper on this topic.
Create an Internal Google Sheets Add-on
How to Insert Multiple Rows in Google Sheets (Easy to Hard)
Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script
Related blog posts
Written guides that go deeper on this question.
Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
No exact channel match cached for “In Google Sheets how to freeze row” yet. Search Better Sheets on YouTube.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
Related questions
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 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 →Google Sheets how to freeze row
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 →How do i 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 panes 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 →Need more than a quick answer?
Membership unlocks 636+ tutorials, unlimited generators, and every template.