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