Excel: Want repeating headers, EXCEPT on last page

[jonnysnow]

I have a document in Excel that should have column headings repeated on all pages, except that the last page is a summary page and doesn't have the same formatting at all. I want to find some way of turning off the automatic header.

Right now (using Excel 2003), I go to 'Page Setup', go to the 'Sheet' tab, and under 'Print titles'/Rows to repeat at top' I select the first line.

Is there a way to keep this feature for most of the printed document, but turn it off at a specified point?

 

[SkipVought]

Hi,

There is no way of conditionally controlling the column headings in all pages.

But you could do it with a macro. Get the process down and then turn on your macro recorder and record the process of printing all but the last page with headings and then the summary page without.

If it were me, I'd put the SUMMARY on a separate sheet, where it belongs.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[AnotherHiggins]

Put your summary on a separate worksheet. When printing, select Entire Workbook instead of Active Sheet.


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[jonnysnow]

Great! This sounds like what I need.

You know, what I did so far was to put the summary on a different worksheet, but I thought that I'd need to "fool" Excel into printing the right page numbers. (I have a footer that prints 'Page X of Y' and I wanted the numbering to be consecutive and correct.)

So in my main worksheet, after all of my data is finished, at the top of the next page I added: [Force new page]

Then on the summary page worksheet, I hardcoded "Page 12 of 12" in the footer.

So does printing "Entire Workbook" get the page numbering correct?

 

[SkipVought]

Yup!

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}