How do you change the A'B'C cells to text?

[Danielle]

Using Excel '03, is there a way to change the top cells (A, B, C, etc.) so
that when you select to print row & column headings there is text? Also, if
there is a way to do this, is there a way to print only the column headings
and not the rows?

Thanks,

Danielle

 

[Gord Dibben]

Danielle

No way to do this.

Add your own unique names to the columns in row 1 then turn off the column and
row headers in Tools>Options>View.

Select A2 and Window>Freeze Panes to keep row 1 and your header names in view.


Gord Dibben Excel MVP