1.7 Freeze Panes
Long data (thousands of orders) scrolls the header out of view. Freeze Panes keeps rows/columns visible.
Steps in Excel
- Freeze the header row only: View › Window › Freeze Panes › Freeze Top Row.
- Freeze first column only: View › Window › Freeze Panes › Freeze First Column.
- Freeze rows and columns together: click the cell below the rows and right of the columns you want frozen (e.g. C2 freezes row 1 and columns A:B) › View › Window › Freeze Panes › Freeze Panes.
- Undo: View › Window › Freeze Panes › Unfreeze Panes.
Worked example. In Orders (4,800 rows), Shahrukh clicks C2 and chooses Freeze Panes. While scrolling down, the header stays; while scrolling right, Order ID and Order Date stay visible.
Ravindra Bagale's Tip
Many students select the wrong cell when using Freeze Panes, and then a part in the middle gets frozen. Remember the rule: the rows above and the columns to the left of the selected cell are frozen. If you get it wrong, Unfreeze and do it again.
Ravindra Bagale's Tip – मराठी
बरेच students Freeze Panes करताना चुकीचा cell select करतात, आणि मग मधलाच भाग freeze होतो. नियम लक्षात ठेवा: select केलेल्या cell च्या वरच्या rows आणि डावीकडचे columns freeze होतात. चुकलं तर Unfreeze करा आणि पुन्हा करा.
Ravindra Bagale's Tip – हिंदी
बहुत से students Freeze Panes करते समय गलत cell select कर लेते हैं, और फिर बीच का हिस्सा freeze हो जाता है. नियम याद रखो: select किए गए cell के ऊपर की rows और बाईं तरफ़ के columns freeze होते हैं. गलती हो जाए तो Unfreeze करो और फिर से करो.
Worked example — freeze panes
Why
Vikram Rao in Pune and Liam Murphy abroad both need a clear, repeatable way to use freeze panes on a Summit Schools sheet without breaking totals.
What
Freeze Panes is the Excel idea this page teaches. We will walk one tiny example end to end.
How
- Open a blank sheet. In A1 type a short label for freeze panes.
- Enter a small made-up value for Vikram Rao using ₹ where money appears.
- Add a second value for Liam Murphy using $ so you see mixed currencies stay numeric.
- Apply the method from this lesson step by step (menu or formula as shown above).
- Check the result still works inside SUM or a simple check cell.
Formula / action
Follow the formula or ribbon steps shown in this lesson (keep values numeric).Meaning: Once freeze panes is correct on one row, copy the same pattern down the column.
Practice tasks (10+)
Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.
1. Rebuild the smallest example of freeze panes on a blank sheet for NovaCraft Tools.
Hint: Use only the steps on this page. Keep numbers numeric.
2. Change one input for Sana Sheikh and confirm the result updates.
Hint: If the result is stuck, check absolute vs relative references.
3. Repeat the same steps with a £ or € value for Emma Clarke.
Hint: Formatting must not break SUM.
4. Write the result meaning in one plain sentence next to the cell.
Hint: Imagine explaining it to a new joiners.
5. Add a second row and fill the method down.
Hint: Double-click the fill handle if the pattern is consistent.
6. Break the example on purpose, then fix it using this lesson.
Hint: Common break: text instead of a number.
7. Apply freeze panes to a 5-row made-up NovaCraft Tools table.
Hint: Keep column headers clear.
8. Check your answer with a simple total or COUNT.
Hint: A wrong total usually means a format or key mismatch.
9. Swap ₹ and $ on one column and re-check totals.
Hint: Stored values stay the same; only the display changes.
10. List two mistakes beginners make with freeze panes.
Hint: Look back at the tip box on this page.
11. Teach the steps out loud in under one minute.
Hint: Why → What → How.
12. Save the sheet as NovaCraftTo_practice.xlsx.
Hint: Use a clear file name for class.
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
