Consecutive Page Numbering with Multiple Worksheets
THANK YOU!
"Franz Verga" wrote:
Nel post
*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
|