Change column labels

K

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.
 
J

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
 
G

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
 
Top