Once you have set up each sheet how you would like it, is it really so
hard to click on a sheet tab then click the <print icon, and do this
for each sheet you have? You could easily record a macro to do this for
you.
Pete
sammy wrote:
Thanks for your reply. I'll wait and see what else shows up.
Sammy
"Gord Dibben" wrote:
Your original post asked for "consecutive page numbering throughout the
document" but sounds like that was not what you wanted.
You want consecutive numbering for each sheet.
Other than individual print jobs, I have no suggestions.
One of the more knowledgeable VBA people will jump in with some code, I'm sure.
Gord
On Tue, 10 Oct 2006 11:45:03 -0700, sammy
wrote:
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?
Gord Dibben MS Excel MVP