Change column labels

[KRO]

I would like to change the column labels so that when I
scroll down I can still see the heading for that column.

Thanks.

 

[John Wilson]

KRO,

Select cell A2 and then Window/Freeze Panes.
That'll keep everything in the first row visible while
you scroll down.

John

 

[Gord Dibben]

KRO

You can't change the column labels. You hide them using Tools>Options>View
and uncheck "row and column headers".

In row 1 enter some meaningful labels(titles) for the columns.

Select A2 and Window>Freeze Panes to lock row 1 in view as you scroll down the
sheet.

If you select B2 and Freeze Panes, row 1 and column A will be locked in view.

Gord Dibben Excel MVP