Freeze column headings for easy scrolling

Why?

To keep column headings visible regardless of where you scroll in your sheet.

How?

  1. Click View > Normal.

In Excel, click View, then click Normal

  1. Select the row under the column headings.

Select row below column headings

  1. Click Window > Freeze Panes.

Click Window, then click Freeze Panes

Hints

  • You can freeze headings in normal view only.
  • If you freeze panes on a sheet that is already split into panes, the whole upper pane will freeze instead of just the heading row.
  • To unfreeze column headings, click Window > Unfreeze Panes.
  • To print your column headings on every page, on the Layout tab, under Print, click Repeat Titles. In the Rows to repeat at top box, enter the rows that contain your headings.

See also

Freeze rows and columns

Change column width or row height

Fit more text in column headings

 
 
Applies to:
Excel for Mac 2011