two sheets in one printout

[nowfal]

i am using a two sheet work book. i usually take the printout one b
one in the same sheet, now my question : is it possible to take prin
out both the sheet at one time. one sheet is in horizontal another on
is vertical.
thank

 

[Frank Kabel]

Hi
one simple soluution: Record a macro while you printout both sheets
manually step by step. afterwards use this macro to printout both
sheets at once

 

[Ragdyer]

If the page setup for each individual sheet has the page orientation as you
described, one letter and the other landscape, then to print *both* pages
with a single print command, simply select *both* sheet tabs (group them),
and click on "Print".

Hold down <Ctrl> while you click in the tab of the other sheet.
Both tabs will now be white, and you'll see [Group] next to the sheet name
at the top of the screen.

Don't forget to "Ungroup" them when you're finished, otherwise many strange
things can happen when you work on one and forget that the other is linked.

Right click in either sheet tab and choose "UngroupSheets".