Hello again, I want to be able to print all the sheets in a workbook, each
sheet might print on one page or many pages, BUT...

I want the first sheet to start numbering at 1 and then, if sheet one prints
over three pages (numbered 1, 2 & 3), I want sheet two to be numbered
starting at 4, etc...

so the whole book will print as one document with consecutive page numbers
from start to end.

Is there a known way to do this?

Thanks

Michelle

Try selecting all the sheets that you want to print and then printing. Click on
the first tab and ctrl-click on subsequent tabs.

Remember to ungroup the sheets when you're done. Almost everything you do to
one sheet will be done to the others in that grouping.

If you want to print all the sheets, you can show the print dialog:
File|Print (in xl2003 menus)
Select Entire Workbook
in the Print What section -- don't use active sheet(s).



Michelle wrote:
>
> Hello again, I want to be able to print all the sheets in a workbook, each
> sheet might print on one page or many pages, BUT...
>
> I want the first sheet to start numbering at 1 and then, if sheet one prints
> over three pages (numbered 1, 2 & 3), I want sheet two to be numbered
> starting at 4, etc...
>
> so the whole book will print as one document with consecutive page numbers
> from start to end.
>
> Is there a known way to do this?
>
> Thanks
>
> Michelle

--

Dave Peterson

I was just about to reply and tell you that you hadn't addressed my
page-numbering issue, when I tried it and of course you had!

Thanks

M


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Try selecting all the sheets that you want to print and then printing.
> Click on
> the first tab and ctrl-click on subsequent tabs.
>
> Remember to ungroup the sheets when you're done. Almost everything you do
> to
> one sheet will be done to the others in that grouping.
>
> If you want to print all the sheets, you can show the print dialog:
> File|Print (in xl2003 menus)
> Select Entire Workbook
> in the Print What section -- don't use active sheet(s).
>
>
>
> Michelle wrote:
>>
>> Hello again, I want to be able to print all the sheets in a workbook,
>> each
>> sheet might print on one page or many pages, BUT...
>>
>> I want the first sheet to start numbering at 1 and then, if sheet one
>> prints
>> over three pages (numbered 1, 2 & 3), I want sheet two to be numbered
>> starting at 4, etc...
>>
>> so the whole book will print as one document with consecutive page
>> numbers
>> from start to end.
>>
>> Is there a known way to do this?
>>
>> Thanks
>>
>> Michelle
>
> --
>
> Dave Peterson