Printing multiple worksheets in a workbook

[Joe Mac]

A general question -

How can I print multiple Worksheets out of a Workbook with a single print
command, without printing the entire Workbook...

Simple example which does not reflect the real condition:
Workbook A.xls contains Sheet1, Sheet2, Sheet3, Sheet4...

I would like to print Sheet 2 and Sheet 4 with a single print command
without printing the entire Workbook...

 

[Joel]

You can activate multiple worksheets by holding down the CNTL button and
selecting the multiple sheet tabs. Then when you pring you can prin Active
Sheet(s).

 

[Joe Mac]

Thank you Joel, this worked well and raised the next question...

When I print (preview & print) the now active Worksheets, I receive the
Custom Footer as "1 of 2" and 2 of 2" presumably because Excel is
constructing a backend spool to the printer... each Worksheet has a
consistent Customer Footer designed as "&[Page] of &[Pages]" to show as "2 of
4" and "4 of 4" from a full Workbook print (keeping with the same example)...


Can Excel retain the Customer Footer consistent with the full Workbook, so
that when I select Sheet 2 and Sheet4 the Customer Footer will show as "2 of
4" and "4 of 4"

Thanks again for the assistance-
Joe

 

[Joel]

I don't think so. What you want works with Word, not with excel. I usually
select entire Workbook and then select the Start Page and End Page.
Sometimes I have to do this multiple times.

Thank you Joel, this worked well and raised the next question...

When I print (preview & print) the now active Worksheets, I receive the
Custom Footer as "1 of 2" and 2 of 2" presumably because Excel is
constructing a backend spool to the printer... each Worksheet has a
consistent Customer Footer designed as "&[Page] of &[Pages]" to show as "2 of
4" and "4 of 4" from a full Workbook print (keeping with the same example)...


Can Excel retain the Customer Footer consistent with the full Workbook, so
that when I select Sheet 2 and Sheet4 the Customer Footer will show as "2 of
4" and "4 of 4"

Thanks again for the assistance-
Joe
--

Joe Mac

You can activate multiple worksheets by holding down the CNTL button and
selecting the multiple sheet tabs. Then when you pring you can prin Active
Sheet(s).