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.
Steps
-
1
Decide how many header rows you need visible.
-
2
View → Freeze → 1 row, 2 rows, or Up to current row.
-
3
Or drag the freeze bar under the row numbers.
-
4
Remove with View → Freeze → No rows.
Related tutorials
These videos might help you go deeper on this topic.
Move Blank Rows
Count Merged Rows
Automate Move Blank Rows
How to Insert Multiple Rows in Google Sheets (Easy to Hard)
Dylan Asks: How to Automatically Delete Rows If Cell Contains Value
Bjarne Asks: Can I show the total number of rows minus the header row?
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 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 3 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 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 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 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 subtract numbers in Google Sheets
Use a minus formula such as =A1-B1, or =MINUS(A1, B1). Fill down for a column. Subtracting dates returns day counts; format duration results appropriately.
Get the answer →Need more than a quick answer?
Membership unlocks 636+ tutorials, unlimited generators, and every template.