Printing column headings in Excel

[Colin MacDougall]

Hi,
This should be easy to do, but I can't work out how.....
I have a simple Excel spreadsheet all on one sheet.
When printed it covers several pages. I would like
to have a heading printed on each page to indicate
what each column is. I can make this happen by
inserting a 'heading' to the row immediately following
a page break. Can Excel print my headings without
me having to manually insert each one after the page
breaks ?

Thanks,

Colin

 

[RWN]

"File->Page Setup->Sheet"
Under "Print Titles" set the "Rows to repeat at top" to your heading row
($1:$1" will repeat row 1 on each sheet).