printing two worksheets as a double sided single page

rh270560

New Member
Joined
Sep 12, 2002
Messages
2
We use forms at work created by the powers that be on Excel that are double sided documents, created with page 1 on say Sheet 1, and the reverse on sheet 2. Here's the problem: The reverse is usually set up for landscape and the front for portrait, so copying & pasting it all into one document doesn't produce the desired result. What I would like to know is, is there a means of printing two sheets within the same work book as a single, double sided piece of paper? Clicking the two tabs and Ctrl P' ing works but won't treat the two sheets as one document and double side the pages - is there a way of forcing Excel to treat the two sheets as one? Thanks in advance!
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Watch MrExcel Video

Forum statistics

Threads
1,118,335
Messages
5,571,608
Members
412,407
Latest member
ElmerCC
Top