When working with a massive spreadsheet containing hundreds of rows of data, scrolling down is incredibly frustrating. The moment you scroll past the first few lines, your header row—the critical labels telling you what “Column H” or “Column J” actually represents—disappears off the top of the screen. You are left staring at a sea of numbers with no context. To solve this, you need to use Google Sheets’ “Freeze” feature to lock those critical rows or columns in place.
What Does “Freezing” Mean?
Freezing a row or a column anchors it to the screen. If you freeze Row 1 (your headers), that row will remain permanently stuck to the top of your web browser, no matter how far down you scroll through the data. The rest of the spreadsheet simply slides underneath it. This does not affect how the document prints or how the data is calculated; it only changes how it is visually displayed on your screen.
How to Freeze a Row (Headers)
The most common use case is locking the very first row of a spreadsheet.
- Open your document in Google Sheets.
- Look at the main menu bar at the top of the screen and click on View.
- Hover your mouse cursor over the Freeze option in the dropdown menu.
- Select 1 row.
You will instantly see a thick gray line appear beneath Row 1. If you try scrolling down, you will see that the header row remains perfectly locked in place.
How to Freeze Multiple Rows
Sometimes your headers take up two or three rows. You can lock multiple rows at once, but the process is slightly different.
- Click the row number on the far left side of the screen to highlight the bottom-most row you want to freeze (e.g., click the number ‘3’ to highlight the entire third row).
- Click View > Freeze.
- Select Up to row 3.
Everything from Row 1 down to Row 3 is now locked together as a single block at the top of your screen.
How to Freeze Columns
If you have a very wide spreadsheet (like a yearly budget with 12 months of columns), you will lose sight of the names in Column A when you scroll horizontally to December in Column M. You can freeze columns using the exact same method.
- Click View > Freeze.
- Select 1 column to lock Column A.
A thick gray line will appear to the right of Column A. Now, as you scroll horizontally to the right, the names in the first column will remain anchored to the left edge of your screen.
How to Unfreeze Everything
If you inherit a messy spreadsheet from a coworker with multiple frozen sections that are making it hard to read on a small laptop screen, you can easily remove the locks.
- To remove row locks: Click View > Freeze > No rows.
- To remove column locks: Click View > Freeze > No columns.