How to freeze 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.
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
Can a Google Sheet have DRM?
The First Thing I Do When Starting a Google Sheet
3 Free Tools to Make Your Google Sheets Better
Google Sheets Easter Eggs Beyond PRIDE
Related blog posts
Written guides that go deeper on this question.
Quick Google Sheets Tips
Boost productivity and streamline your workflow in Google Sheets with our quick tips and free tools. Breathe new life into your spreadsheets today.
Read post →What's Better Than Google Sheets?
Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.
Read post →Protect Your Formulas from Accidental Deletion in Google Sheets
Ever spent hours crafting the perfect formula in Google Sheets, only to accidentally delete it? It's a frustrating experience that can derail your productivity. Fear not! In this guide, we'll unveil some clever tricks to safeguard your hard work.
Read post →Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
No exact channel match cached for “How to freeze Google Sheets” 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 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 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 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 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?
636+ 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.