Consecutive Page Numbering with Multiple Worksheets

I have a file that has multiple worksheets. I print all worksheets together
as they make up one master document. I would like to use a footer and have
the pages automatically number. However, using the basic tools in Excel, the
insert page number function starts from 1 at each new worksheet. I would
settle for the ability to type in the number I would like each worksheet to
start numbering from. For example, if the first worksheet prints 3 pages, I
could tell the second worksheet to start numbering at 4. Any suggestions?

Nel post news:223A3CE5-D6AF-4DEA-92D4-5965B79437C7@microsoft.com
*Daria* ha scritto:

> I have a file that has multiple worksheets. I print all worksheets
> together as they make up one master document. I would like to use a
> footer and have the pages automatically number. However, using the
> basic tools in Excel, the insert page number function starts from 1
> at each new worksheet. I would settle for the ability to type in the
> number I would like each worksheet to start numbering from. For
> example, if the first worksheet prints 3 pages, I could tell the
> second worksheet to start numbering at 4. Any suggestions?

Hi Daria,

You have just to group your worksheets before printing: holding down the
Shift key select the first and then the last sheet to print, from Print
Preview you can see that the page numbers are countinuos from the first to
the last sheet.
Instead, if you don't want to print every sheet in your file, hold down the
Ctrl Key while selecting the sheets to print.

--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Ciao

Franz Verga from Italy

THANK YOU!

"Franz Verga" wrote:

> Nel post news:223A3CE5-D6AF-4DEA-92D4-5965B79437C7@microsoft.com
> *Daria* ha scritto:
>
> > I have a file that has multiple worksheets. I print all worksheets
> > together as they make up one master document. I would like to use a
> > footer and have the pages automatically number. However, using the
> > basic tools in Excel, the insert page number function starts from 1
> > at each new worksheet. I would settle for the ability to type in the
> > number I would like each worksheet to start numbering from. For
> > example, if the first worksheet prints 3 pages, I could tell the
> > second worksheet to start numbering at 4. Any suggestions?
>
> Hi Daria,
>
> You have just to group your worksheets before printing: holding down the
> Shift key select the first and then the last sheet to print, from Print
> Preview you can see that the page numbers are countinuos from the first to
> the last sheet.
> Instead, if you don't want to print every sheet in your file, hold down the
> Ctrl Key while selecting the sheets to print.
>
> --
> (I'm not sure of names of menues, option and commands, because
> translating from the Italian version of Excel...)
>
> Hope I helped you.
>
> Ciao
>
> Franz Verga from Italy
>
>
>

Nel post news:9DA03726-6207-46DB-A127-8C68F19BBD9D@microsoft.com
*Daria* ha scritto:

> THANK YOU!

You're welcome.

Thanks for the feedback

--
I'm glad I helped you.

Ciao

Franz Verga from Italy

Thank you Franz Verga for your input. I was looking for this information and it worked great. Really appreciate you posting this information.

Leah from Miami, Florida