ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Duplex Printing of Workbook with multiple worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/220707-duplex-printing-workbook-multiple-worksheets.html)

Lenny

Duplex Printing of Workbook with multiple worksheets
 
I have a workbook with 12 worksheets... I want to print the worksheets out
consecutively back to back. The contents of each worksheet is only 1 page
each when printed out.

When I select print Entire Workbook and print preview... the preview shows
the pages continuous in the preview. But, when it prints, it prints each
worksheet out as a single sided page....I have played around with the
settings and cannot seem to get it to print the entire contents of the
workbook doublesided. Can it even be accomplished?

Lenny

Bob I

Duplex Printing of Workbook with multiple worksheets
 
Manually? Print 6 worksheets, flip them back over into the paper tray,
print the other 6 worksheets

Lenny wrote:

I have a workbook with 12 worksheets... I want to print the worksheets out
consecutively back to back. The contents of each worksheet is only 1 page
each when printed out.

When I select print Entire Workbook and print preview... the preview shows
the pages continuous in the preview. But, when it prints, it prints each
worksheet out as a single sided page....I have played around with the
settings and cannot seem to get it to print the entire contents of the
workbook doublesided. Can it even be accomplished?

Lenny



Shane Devenshire[_2_]

Duplex Printing of Workbook with multiple worksheets
 
Hi,

With my duplex printer I need to choose File, Print, Properties and find the
tab that allows 2 sided printing and turn it on.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Lenny" wrote:

I have a workbook with 12 worksheets... I want to print the worksheets out
consecutively back to back. The contents of each worksheet is only 1 page
each when printed out.

When I select print Entire Workbook and print preview... the preview shows
the pages continuous in the preview. But, when it prints, it prints each
worksheet out as a single sided page....I have played around with the
settings and cannot seem to get it to print the entire contents of the
workbook doublesided. Can it even be accomplished?

Lenny



All times are GMT +1. The time now is 04:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com