Print multiple sheets in one print job

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JerryK - 27 Oct 2004 05:27 GMT

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

Reply to this Message

Bruce Sinclair - 27 Oct 2004 05:42 GMT

>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
[quoted text clipped - 3 lines]
>
>Is this possible?

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)

Reply to this Message

JerryK - 27 Oct 2004 18:26 GMT

It works great. 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
[quoted text clipped - 21 lines]
> Caution ===== followups may have been changed to relevant groups
> (if there were any)

Reply to this Message

Nadeem Shafiullah - 28 Oct 2004 03:26 GMT

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

> It works great. Thank you.
> Jerry
[quoted text clipped - 28 lines]
>> Caution ===== followups may have been changed to relevant groups
>> (if there were any)

Reply to this Message

Paul Cunliffe - 28 Oct 2004 09:06 GMT

Have a look at http://www.asap-utilities.com/

Their free download allows easy picking of sheets to print, plus lots,lots more.

Paul

> 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
[quoted text clipped - 6 lines]
> Thank you.
> Jerry

Reply to this Message