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.
Visual walkthrough
View›Freeze Panes›Freeze Panes
Before
Headings disappear when you scroll.
After
Row 1 and column A stay visible after freezing at B2.
Check the result
Scroll in both directions to check the frozen area.
Step-by-step instructions
- Decide which rows and columns should stay visible. To freeze row 1 and column A, select B2.
- Choose View → Freeze Panes → Freeze Panes.
- Scroll down and right. Row 1 and column A should remain on screen.
- To change the frozen area, choose View → Freeze Panes → Unfreeze Panes, select a new cell and freeze again.
Frequently asked questions
Can I freeze only the first row?
Yes. Choose View → Freeze Panes → Freeze Top Row. You do not need to select B2 for that option.
Reference: Microsoft Support