Excel Study · Module 2: Entering & formatting data
Class 16Freeze Panes: headers stay put
Basics1:22 videoFree
Long list? Scroll down and the headers vanish. View → Freeze Panes → Freeze Top Row keeps row 1 on screen.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, my title is in row 1 and my column headers are in row 2. How do I keep both rows visible at the top while I scroll down? Answer in short steps.
The answer that works
✓ checked in Excel1. Click cell A3 (the first cell in the row below both rows you want frozen). 2. Go to the View tab on the ribbon. 3. Click Freeze Panes (in the Window group). 4. Select Freeze Panes from the dropdown. To undo it later: View → Freeze Panes → Unfreeze Panes.
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.