column header

  • Thread starter Thread starter KIRK
  • Start date Start date
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.
 
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
 
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
 
Back
Top