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: 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" <gm@dataforcesoftware.com> wrote in message
news:u6M0s%23MfFHA.2496@TK2MSFTNGP15.phx.gbl...
> 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" <gm@dataforcesoftware.com> wrote in message
news:u6M0s%23MfFHA.2496@TK2MSFTNGP15.phx.gbl...
>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
>