print 1 paper from 2 sheets

E

Eric Tiethoff

How can i print the range a1:m10 from sheet 1 AND a11:r10 from sheet 2 on
ONE piece of paper ? Anybody knows a solution ?
 
D

Dave Peterson

Create a new sheet.
Copy A1:M10 of Sheet1 to that new sheet
Copy A11:R10 of sheet 2 to that new sheet
Print from there.

If you have to do this lots of times, you can
select A1:M10
edit|copy
to the new sheet
shift-edit|paste picture link

And the same with A11:R10.

By using paste picture link, any change you make to those original ranges will
be reflected in the pictures.
 
Top