Can I set column headings on every page and exlcude some pages?
 

I have some reports that are between 30 and 40 pages long and I usually use
the page setup option to put column headings on every page, but some of the
pages do not need column headings and I cannot find a way to eliminate the
column headings on those few pages without manually copying headings on each
page I would like them to appear which is very time consuming. Please help
with any information to make this an easier process.

Hi Julia,
You do not need to start column headers with row 1, you could delay
to a later row. Such as placing logos and a letter on page one.

Other options including starting and stopping the print for each
page or segment of pages. Problem is managing the rows,
printed on each page, so they are the same with or without the
headings, so you will basically have to insert all of your page
breaks manually which take the fun out of it.

Headings for Columns, and Page Numbering
http://www.mvps.org/dmcritchie/excel...ls.htm#restart
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Julia" wrote in message ...
I have some reports that are between 30 and 40 pages long and I usually use
the page setup option to put column headings on every page, but some of the
pages do not need column headings and I cannot find a way to eliminate the
column headings on those few pages without manually copying headings on each
page I would like them to appear which is very time consuming. Please help
with any information to make this an easier process.