any way to redisplay column headings after page break?

G

Gerald Morris

I have a worksheet which can sometimes go to more than one page.
Is there a way to have the column headings get added automatically after a
page break?

Gerald
 
P

Paul B

Gerald, if this is for printing have a look at file, page setup, sheet, rows
to repeat at top and select the row you want
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top