Hi,

I have a similar but opposite problem because I want each worksheet to print
with its own set of page numbers but all I get is consecutive numbers, for
example, from 1 to 30. I want the first worksheet to be numbered 1 - 6 of 6,
the second worksheet to be numbered 1 - 5 of 5...

If I select one worksheet at a time, I can get what I want, but if I select
multiple worksheets, the total page number reflects the total number of pages
in all sheets and not the number of pages in the individual worksheet.

I'm sorry if this is confusing but all I want is a footer that has "page #
of pages" relative to the individual worksheets but I want to print multiple
worksheets at the same time. It seems that this is easy if I just have the
page number, but gets complicated when I add the "of pages" part.

Any other suggestions?

TIA,
Sammy


"Gord Dibben" wrote:

Select a sheet and right-click on the tab and "Select all sheets"

Go to ViewHeaders and footers.

Select from the drop-down "Page 1 of ?"

OK out.

Right-click and "ungroup sheets".

FilePrintPrint WhatEntire Workbook


Gord Dibben MS Excel MVP

On Wed, 27 Sep 2006 11:02:02 -0700, Becot
wrote:

I have an Excel spreadsheet that has 3 separate worksheets in it.

The documents will all be printed together as one large document and I would
like consecutive page numbering throughout the document. So far, all I can
get is page 1-3 of the first worksheet, page 1-4 of the second, etc.

Any advice? Can this be done?