A long spreadsheet is much easier to read when the column headings stay visible. Freeze Panes anchors a part of the worksheet while the rest scrolls. The important decision is where the boundary belongs: Excel uses the selected cell to determine which rows and columns remain on screen.
Select the cell below the rows and to the right of the columns you want to keep visible, then choose View → Freeze Panes → Freeze Panes.
Go straight to the stepsBefore you begin
This changes the scrolling view. It does not protect cells from editing or automatically repeat headings on printed pages.
What you’ll need
- Excel with the Freeze Panes command
- A worksheet with headings
Let’s do this
Step by step
- 01
Identify the headings you need
Find the last heading row and any identifying columns, such as a product name or date. Decide whether you need rows, columns, or both to stay visible.
- 02
Select the boundary cell
To keep row 1 and column A visible, select B2. To keep the first two rows and first two columns, select C3. The frozen area will be above and to the left.
- 03
Freeze the panes
Open View → Freeze Panes → Freeze Panes. Scroll down and across to test both directions.
- 04
Adjust if necessary
If the wrong area stays fixed, choose View → Freeze Panes → Unfreeze Panes. Select the correct cell and repeat.
Three examples to make the selection click
For a budget with labels in row 1 and months across the top, selecting A2 anchors the first row without reserving an extra column. For a stock list with item names in column A, B1 anchors that identifying column without adding a heading row.
For a report with a title in row 1 and column headings in row 2, B3 keeps both those rows plus column A. Check whether the title really needs to stay visible: a large decorative heading can leave very little room for the data on a small screen.
Freeze only what helps you read
A useful frozen area answers “which row is this?” and “what does this column mean?” without swallowing the worksheet. Test at the window size you normally use. If half the sheet becomes immovable, simplify the headings or freeze a smaller area.
A quick final check
- Headings remain visible when scrolling.
- The frozen area leaves enough room for data.
- Both vertical and horizontal scrolling were tested.
Common questions & sticking points
Why did Excel freeze the wrong rows?
The selection determines the boundary. Unfreeze, choose the cell immediately below and to the right of the desired area, and try again.
Does Freeze Panes stop someone editing my spreadsheet?
No. Worksheet protection is a different feature.
Sources & further reading Optional
References used to check this guide. Follow your product’s own safety instructions where its design differs.
Last source check: September 21, 2026