Printing multiple worksheets in a workbook

  • Thread starter Thread starter Joe Mac
  • Start date Start date
J

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...
 
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).
 
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
 
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.

Joe Mac said:
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


Joel said:
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).
Click to expand...
Click to expand...
 
Back
Top