Office Dễ Hiểu

How to freeze rows and columns in Excel

Keep your headings and identifiers visible while scrolling through a large worksheet.

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

ViewFreeze PanesFreeze 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

  1. Decide which rows and columns should stay visible. To freeze row 1 and column A, select B2.
  2. Choose View → Freeze Panes → Freeze Panes.
  3. Scroll down and right. Row 1 and column A should remain on screen.
  4. 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