Theory
Which column was the price again?
Meera scrolls down to row 340 of her big sheet to check an item, and realises she has no idea which column is which: the heading row (Item, Price, Qty) scrolled off the top hundreds of rows ago. She keeps scrolling back up to check, then back down. Maddening.
Big sheets need tools that keep you oriented. Three of them, Freeze, Split, Hide, turn a 500-row monster into something you can actually read. Meera's scrolling problem has a one-click cure.
Theory
A pinned label on a long scroll
Imagine reading a very long paper scroll where the column headings are written only at the very top. Unroll to the middle and you have forgotten what each column means. Freeze Panes is a pin that keeps that heading strip fixed on screen no matter how far you unroll. The data scrolls beneath it; the labels stay put. Simple, and the single most-used view trick in Excel.
At a glance
Three tools for big sheets
| Tool | What it does | Data changed? |
|---|---|---|
| Freeze Panes | Pins top rows / left columns while scrolling | No |
| Split | Divides window into independent scroll panes | No |
| Hide | Removes rows/columns from view | No (still there) |
Theory
The three, precisely
- Freeze Panes (View tab): Freeze Top Row keeps row 1 visible; Freeze First Column keeps column A visible; Freeze Panes at a selected cell locks everything above and left of it. Headings stay; data scrolls.
- Split (View > Split): breaks the window into 2 or 4 panes that scroll independently, so you can compare row 5 and row 400 side by side in the same sheet.
- Hide (right-click a row/column header > Hide): removes it from view. The data and its formulas still exist and still compute; Unhide brings it back.
Quiz
Meera freezes the top row, then scrolls down to row 300. What does she see?
- Row 1 (the headings) stays fixed at the top while rows 300+ scroll below it
- Rows 1 to 300 all stay on screen at once
- Row 1's data is copied down to row 300
- The sheet stops scrolling past row 1
Show the answer
Row 1 (the headings) stays fixed at the top while rows 300+ scroll below it
Freeze Top Row pins only row 1 on screen; the rest of the sheet scrolls beneath it, so at row 300 the headings are still visible up top. No data is copied or duplicated, it is purely a view that keeps the labels in place. "What does Freeze Panes do?" is a reliable one-mark question.
Think first
Hidden, not deleted
Meera hides her secret cost-price column (column D) before showing the sheet to a customer. Her profit formula in column E uses D. Does the profit still calculate correctly with D hidden? Think it through.
Show the answer
Yes. Hiding only removes column D from view; the data is still there and formulas that reference it keep working perfectly. Column E's profit computes from the hidden D as normal. This is the whole point of Hide versus Delete: Hide conceals, Delete destroys. Unhide D anytime and it reappears untouched.
Watch out
Where marks leak
Confusing Freeze (headings stay fixed, one view) with Split (independent scrolling panes). Thinking Hide deletes data, it only conceals; formulas using hidden cells still compute (the profit example). And a subtle trap: hidden rows/columns are skipped when you copy a visible range in some cases but still printed unless excluded, worth a line in careful answers. Delete-vs-hide is the classic contrast.
Theory
Unit 1, complete
You can now build, format, protect, print and navigate a worksheet, everything a real office needs before any calculation happens. Meera's sheet is ready for the real magic. Unit 2 is where the spreadsheet earns its name: formulas. Next lesson gives Meera SUM, AVERAGE, MAX, MIN and the star of inventory work, SUMIF, so her totals compute themselves.
Summary
Key takeaways
- Freeze Panes pins top rows and/or left columns so headings stay visible while scrolling.
- Freeze Top Row, Freeze First Column, or Freeze Panes at a selected cell.
- Split divides the window into independently scrolling panes to compare distant areas.
- Hide removes rows/columns from view WITHOUT deleting; formulas still compute; Unhide restores.
- None of these change the data, they are all view tools.
- Memory hook: Freeze pins the heading label to the top of a long scroll.