any way to redisplay column headings after page break?
 

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

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

"Gerald Morris" wrote in message
...
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

Gerald: For printing, we use File--Page setup--Sheet tab and choose the
Rows to Repeat at Top. For viewing, click on the cell just below your
headings and in column A. Hit Window--Freeze Panes.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Gerald Morris" wrote in message
...
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