How to Freeze Rows in Google Sheets
Learn how to freeze rows in Google Sheets, keep headers visible, freeze columns too, avoid mistakes, troubleshoot mobile limits, and read FAQs.
Quick Answer
To freeze rows in Google Sheets, open the sheet, choose View > Freeze, then select 1 row, 2 rows, or Up to current row to keep header rows visible while scrolling.
What You Need
- Google Sheets file
- Edit access
- Header row or row to freeze
- Browser or Sheets app
Safety Precautions
- Freeze rows only for layout; it does not protect data from edits.
- Make sure you freeze the correct header rows.
- Check filtered views and shared sheets after changing layout.
- Mobile menus may differ from desktop.
Step-by-Step Instructions
- Step 1
Open the sheet
Go to the Google Sheets file you want to adjust.
- Step 2
Select a row if needed
Click the row below the rows you want to freeze.
- Step 3
Open View
Click View in the top menu.
- Step 4
Choose Freeze
Hover over Freeze to see row options.
- Step 5
Pick the row setting
Choose 1 row, 2 rows, or Up to current row.
- Step 6
Scroll to test
Scroll down and confirm the frozen rows stay visible.
- Step 7
Unfreeze if needed
Use View > Freeze > No rows to remove it.
Practical Example
Example: You freeze the first row of a budget spreadsheet so column headings stay visible while entering monthly expenses.
Common Mistakes
- Freezing the wrong row
- Confusing freeze with protect range
- Forgetting to test scrolling
- Expecting freeze to print automatically
- Not checking shared sheet views
- Using mobile instructions on desktop
Troubleshooting
Wrong rows are frozen
Unfreeze, select the correct row, and choose Up to current row.
Freeze option is missing
Check permissions or use the desktop browser version.
Rows are still editable
Use protected ranges if you need edit protection.
Printed sheet does not repeat headers
Use print settings for repeated headers if available.
Helpful Internal Links
FAQs
Can I freeze more than one row?
Yes, use 2 rows or Up to current row.
Can I freeze columns too?
Yes, View > Freeze also includes column options.
Does freezing protect cells?
No, it only keeps rows visible while scrolling.
How do I unfreeze rows?
Choose View > Freeze > No rows.
Related Guides
How to Move Columns in Excel
Learn how to move columns in Excel by drag-and-drop, cut and insert, table tips, formula checks, common mistakes, troubleshooting, and FAQs.
How to Add Drop Down List in Excel
Learn how to add a drop down list in Excel using Data Validation, source lists, error alerts, common mistakes, troubleshooting, and FAQs.
How to Make a Line Graph in Google Sheets
Learn how to make a line graph in Google Sheets, prepare data, insert chart, label axes, avoid mistakes, troubleshoot, and read FAQs.
Help us improve this guide
Tell us about an outdated instruction, unclear step, broken link or safety concern. Do not include passwords, account numbers, medical records or other sensitive information.