Keep the column names in sight.
Freeze a header row so scrolling does not turn your sheet into a guessing game.
Give your columns a steady label.
You are halfway down a list and cannot remember whether the number at the right is quantity, price, or stock remaining. The data has not changed, but the labels have scrolled away. Freezing a header keeps those labels visible.
In a practice Google Sheet, put Item, Quantity, and Location across row 1. Add enough rows to make the sheet scroll. Choose View, then Freeze, then 1 row. The top row now stays visible while the rows below it move.
A steady header
Scroll ↓ Column labels leave the view
Item | Quantity | Location Data scrolls below
Freezing affects the view.
A frozen row is still editable. It is not a permission setting and does not protect the cells from changes. Think of it as keeping a ruler at the top of your work, not locking a cabinet.
Check that your real header is in the row you freeze. If you have a large title above the column labels, freezing only row 1 may keep the title while losing the useful names. For this exercise, use a simple one-row header.
Row 1: Item | Quantity | Location View → Freeze → 1 row
Make it yours.
- Create a header and several rows of sample items.
- Freeze one row using the View menu.
- Scroll down, then choose View → Freeze → No rows and compare.
What changed when you tried it?
A little nudge
Use enough rows that scrolling actually moves the header off screen.
What to look for
With freezing enabled, row 1 remains visible as the other rows scroll. With No rows, it scrolls away.
Take it one small step further
Freeze the first column too and compare horizontal scrolling.
Keep the meaning of the data next to the data.
Read more: Google Sheets · Freeze rows and columns ↗
No submission needed. This one is just for you.