column header

K

KIRK

How do I assign a column header to replace the default
a,b,c,d...
I also want these column headers to be printed on the top
of each page how do you do this.
 
B

Bernard V Liengme

You cannot replace the column or row headers other than to replace a,b,c by
1,2,3 (Tools|Options ...use RC )
You can put headers in a row and specify that these are to be printed at the
top of each page.
Use File|PageSetup, open the Sheet tab and fill in Rows to Repeat at Top,
Note_ you cannot do this if you open PageSetup from the Print Preview menu.

Bernard
 
R

Ron de Bruin

Hi Kirk

You can use window -Freeze Panes in the menubar
To freeze the first column and Row.
Select cell b2 and do window -Freeze Panes

You can put your own headers in the first row and column then

Under Tools -options -View uncheck row & column headers so
the default row and column headers are gone
 
Top