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 करो और फिर से करो.
Practice task
Freeze row 1 and columns A:B of your Orders sheet. Then try View › Window › Split and compare it with Freeze Panes.