Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|