Ravindra BagaleCourses & study guides Track your progress
Easy challenge

Easy: Freeze panes on the wrong row

By · Free ·

Absolute refsNumbers as textLeading spacesFilter left onChart range% vs decimalDuplicate headerROUND vs displayFreeze panesPaste valuesVLOOKUP & textVLOOKUP col indexHLOOKUP TRUESUMIF spacesCOUNTIFS ORIF nest orderDate serialINDEX MATCHWildcard COUNTIFMixed currencyCircular & datesCircular interest3D sum renameNamed range staleCF vs IFPivot staleHard-coded NPVValidation movedPQ step orderTyped-over formulaSUM wrong anchorsFiscal year Apr–MarFind all bugsInterview oral

Freeze was set at A4 (title area). The real header is row 5 — it scrolls away. Unfreeze, select A6, Freeze Panes.

About this data: Made-up ledger for Arjun Malhotra (Indore) and Sofia Rossi (Rome). Practice only.
Download broken workbook Download fixed (after you try)

Why → What → How

Why: Wrong freeze makes every scroll painful and causes mis-keyed columns.

What: Long ledger; broken freezes at A4. Fixed freezes at A6 so row 5 header stays.

How:

  1. Open Ledger.
  2. Scroll down — header disappears.
  3. View → Unfreeze.
  4. Select A6 → Freeze Panes.

Ravindra Bagale’s Tip

Select the cell *below* the header row (and right of frozen cols) before Freeze Panes.

Bugs explained (with mini examples)

Bug 1 — Freeze above header

Titles scroll away.

Bug 2 — Title row frozen instead

Useless freeze.

Practice tasks (12)

  1. Task 1. Which row is the real header?
    Hint: 5.
  2. Task 2. Where is freeze now (broken)?
    Hint: A4.
  3. Task 3. Unfreeze panes.
    Hint: View menu.
  4. Task 4. Freeze at A6.
    Hint: Header stays.
  5. Task 5. Scroll test.
    Hint: Titles visible.
  6. Task 6. Interview sentence.
    Hint: “Freeze was one row too high.”
  7. Task 7. Freeze first column too (B6).
    Hint: Optional.
  8. Task 8. Why freeze title row alone fails.
    Hint: Header still moves.
  9. Task 9. Large sheets need freeze.
    Hint: Yes.
  10. Task 10. Unfreeze before re-freeze.
    Hint: Clean.
  11. Task 11. Bonus: New Window for dual view.
    Hint: Optional.
  12. Task 12. Save.
    Hint: Done.
Step-by-step solution (try first)
  1. Unfreeze. Select A6 → Freeze Panes. Header row 5 remains visible.

Quick quiz

Q1. To keep row 5 visible while scrolling, freeze at:
Q2. Freeze above the header causes:
Q3. First step when freeze is wrong:
Q4. Freeze Panes uses the cell you:
Q5. This ledger’s header row is: