How to freeze a row in Google Sheets
Click View → Freeze → 1 row to lock the top header while you scroll. You can also drag the thick gray freeze handle just below row 1 (or to the right of column A for columns). Frozen rows stay visible as you move through long lists. To undo, choose View → Freeze → No rows.
Steps
-
1
Open the sheet with your header in row 1.
-
2
Go to View → Freeze → 1 row.
-
3
Or drag the freeze bar below row 1 down to freeze more rows.
-
4
Clear it with View → Freeze → No rows.
Related tutorials
These videos might help you go deeper on this topic.
Move Blank Rows
Count Merged Rows
Countdown Blank Row
Automate Move Blank Rows
Move Cells to New Row with Formula
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.
Freeze rows and columns
Freezing locks the top rows or left columns in place while the rest of the sheet scrolls. View > Freeze lets you pin ...
Open →COLUMN()
Google Sheets COLUMN() function guide
Open →COLUMNS()
Google Sheets COLUMNS() function guide
Open →ROWS()
Google Sheets ROWS() function guide
Open →Related questions
How to freeze a 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 to freeze row 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 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 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 →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.
Get the answer →How to sort a pivot table in Google Sheets
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Get the answer →Need more than a quick answer?
Membership unlocks 636+ tutorials, unlimited generators, and every template.