Print multiple sheets in one print job

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
 
B

Bruce Sinclair

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

JerryK

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

Nadeem Shafiullah

You may also select all sheets by right clicking on worksheet tab and then
issuing print command.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A Macro to Print sheets in mult w.books 2
print all sheets in one print job so I can staple them 2
Print multiple on one page 2
Print multiple sheets from a validation list 1
Y/N and print job sequencer 10
print 2 sheets on one paper 5
A macro code to print multiple sheets in different w.books 3
One Print Job to Multiple Printers 2

Top