Printing Multiple Worksheets

Is there a way to print multiple worksheets at a time but have their
numbering stay true to the tab? Say you have 4 worksheets in a workbook.
The first worksheet is 5 pages, the second 4, the third 8. Right now if I
click ctrl and choose all the worksheets to print it totals all the pages and
in the footer it starts printing 1 of 17 etc. What I would like for it to do
is print 1 of 5, 2 of 5 etc for the first worksheet; 1 of 4, 2 of 4 etc for
the second worksheet.... Is there a way to make Excel do this?

You will need to File Page Setup for each sheet. On the Page tab set First
page number to 1; on the Header/Footer tab select Custom Footer, put your
cursor in the appropriate location (Left, Middle, or Right) and click Page
number, then type a space and the word "of" and another space, then click the
Pages button, Click OK twice. Repeat for each tab and you should be ready
to go.

"Linda" wrote:

Is there a way to print multiple worksheets at a time but have their
numbering stay true to the tab? Say you have 4 worksheets in a workbook.
The first worksheet is 5 pages, the second 4, the third 8. Right now if I
click ctrl and choose all the worksheets to print it totals all the pages and
in the footer it starts printing 1 of 17 etc. What I would like for it to do
is print 1 of 5, 2 of 5 etc for the first worksheet; 1 of 4, 2 of 4 etc for
the second worksheet.... Is there a way to make Excel do this?