Change Column Heading Names

[Carl Jackson]

Is there a way to chage the column heading names in Excel
from A,B,C, etc. to another name such as LastName,
FirstName, etc.?

 

[Bob Phillips]

Carl,

You can't do what you want, but you can fool it.

Type the headings in row 1.

Hide the rows and coilumn headers (Tools>Options View tab and uncheck the
Rows and Cilium headers checkbox.

You could also change the colour of row 1.

 

[Gord Dibben]

If you wish to keep these headings that Bob suggests in view no matter how far
down you scroll , select A2 then Window>Freeze Panes.

Gord Dibben Excel MVP - XL97 SR2 & XL2002