ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing multiple worksheets on one page (https://www.excelbanter.com/excel-discussion-misc-queries/20868-printing-multiple-worksheets-one-page.html)

Ben :Dillon

Printing multiple worksheets on one page
 
I have four worksheets that I'd like to print as a one-fold landscape
booklet. This means I need to print two worksheets on one side of a page,
but I can't figure out a way to do this within Excel (PC v2002, btw). Is
this possible, preferably without VB?

Otto Moehrbach

Excel will not do this on its own. You would have to copy/paste, unto one
sheet, what you want printed on one landscape page, then print it.
Of course, VBA can be used to do the copying/pasting and printing. HTH
Otto
"Ben :Dillon" <Ben wrote in message
...
I have four worksheets that I'd like to print as a one-fold landscape
booklet. This means I need to print two worksheets on one side of a page,
but I can't figure out a way to do this within Excel (PC v2002, btw). Is
this possible, preferably without VB?





All times are GMT +1. The time now is 05:21 PM.

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