Print multiple tabs on one page

E

excelQ

How to print multiple tabs in excel onto one page in one print job? Tab1 and
tab2 have different format and cannot be combined into one tab. Need to
print the two worksheets one on top of each other is the same direction.
Tried Report Manager but printed on two pieces of paper. Any suggestions?
 
R

Ragdyer

One way to accomplish something like this is to play around with "pictures".

I'm on an XL97 machine now so,
When you hold down <Shift> and hit <Edit>, you get a different dialog box
.... one that contains "picture " options.

So, select an entire sheet, or part of a sheet, then <Shift> <Edit>,and
click on "Copy Picture".
Navigate to your other sheet and click in a cell at the bottom, and then,
<Shift> <Edit>, and click on "Paste Picture".

Select this entire double sheet and then:
<File> <PrintArea> <Set PrintArea>.

Do a "Print Preview" or print the sheet, and see what you get.

You can make adjustments by eliminating grids, or lining up borders.

Like I said, play around and see if you can come up with something that's
presentable.
 
D

DNA

Maybe I'm misunderstanding your questions, but what I hear is that you have
several worksheets and you want to print all of them at once.

Is that correct? If so, you may want to try something like this:

Public Sub PrintSheets()
Worksheets("Worksheet A").Printout
Worksheets("Worksheet B").Printout
Worksheets("Worksheet C").Printout
' etc...
End Sub


HTH
 
Top