Print multiple sheets in one print job

  • Thread starter Thread starter JerryK
  • Start date Start date
J

JerryK

I want to print several worksheets (e.g. sheet1, sheet 4, and sheet5) in one
print job. This is a frequent task for users of one spreadsheet and would
be much more convenient for them. I could probably write a macro to print
each sheet individually, but it would be nice to print all at one time and
have the printer staple them together.

Is this possible?

Thank you.
Jerry
 
I want to print several worksheets (e.g. sheet1, sheet 4, and sheet5) in one
print job. This is a frequent task for users of one spreadsheet and would
be much more convenient for them. I could probably write a macro to print
each sheet individually, but it would be nice to print all at one time and
have the printer staple them together.

Is this possible?
Click to expand...

Not sure about the stapling, but IIRC, if you just select the sheets you
want to print (cntrl click and/or shift click) and print, it prints them
fine. I get sheet one on page one and sheet 2 on the back (with 1 page
sheets). Looks like the same print job ... so the stapling might work :)

Would that do the job ?



Bruce

------------------------------
Health nuts are going to feel stupid someday, lying in hospitals
dying of nothing.

-Redd Foxx


Caution ===== followups may have been changed to relevant groups
(if there were any)
 
It works great. Thank you.
Jerry

Bruce Sinclair said:
Not sure about the stapling, but IIRC, if you just select the sheets you
want to print (cntrl click and/or shift click) and print, it prints them
fine. I get sheet one on page one and sheet 2 on the back (with 1 page
sheets). Looks like the same print job ... so the stapling might work :)

Would that do the job ?



Bruce

------------------------------
Health nuts are going to feel stupid someday, lying in hospitals
dying of nothing.

-Redd Foxx


Caution ===== followups may have been changed to relevant groups
(if there were any)
Click to expand...
 
You may also select all sheets by right clicking on worksheet tab and then
issuing print command.
 
Back
Top