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" wrote in message
...
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