Printing multiple worksheets on one page

G

Guest

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?
 
O

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
 

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

Printing Multiple Worksheets on one page 2
printing as booklet 3
printing multiple worksheets in a workbook 1
print several worksheets on one page 1
Repeat printing rows in multiple worksheets 19
Not printing the entire workbook 2
Printing multiple worksheets in a workbook 3
Change multiple worksheets at one time to print in color 1

Top