- How to print Entire Workbook as a single print job?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

S>B>S - 23 Jul 2004 19:41 GMT

Some Excel documents with tow or more worksheets are sent page-by-page to
the printer when Entire Workbook option is checked (and some are sent as a
single multiage print job).

Is there anyway to ensure that, if Entire Workbook option is selected, a
single multiage print job would be sent to the printer?

Reply to this Message

Rob Bovey - 23 Jul 2004 19:49 GMT

> Some Excel documents with tow or more worksheets are sent page-by-page to
> the printer when Entire Workbook option is checked (and some are sent as a
> single multiage print job).
>
> Is there anyway to ensure that, if Entire Workbook option is selected, a
> single multiage print job would be sent to the printer?

Instead of using the entire workbook option you might try selecting all
of the worksheets (right-click on the first sheet tab and choose Select All
Sheets from the shortcut menu) and then just print using the default print
setting. Not absolutely sure this will solve your problem but it's worth a
try.

Signature

Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

Reply to this Message

Paul Cundle - 24 Jul 2004 15:50 GMT

Unfortunately, that's not likely to help very much. One thing to be sure of
is that each worksheet is set to print at the same resolution. It's also
worth checking that margins etc. are the same throughout.

Your problem is a common one with no decent solution. You could try looking
here:
http://groups.google.com/groups?group=microsoft.public.excel.printing
but the question is asked a lot more often than it is answered.

Paul C,

Signature

>> Some Excel documents with tow or more worksheets are sent
>> page-by-page to the printer when Entire Workbook option is checked
[quoted text clipped - 8 lines]
> print using the default print setting. Not absolutely sure this will
> solve your problem but it's worth a try.

Reply to this Message