2 sheets on 1 paper

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ive created several sheets in Excel....now I want to have it printet on a duplex printer...so I want the 2 sheets to be on same paper...one on front and the other on the back..

So far I havent found a solution...can anybody help me, plzzz ???
 
AFAIK, Excel treats each Excel sheet as a separate print job. As such, your
only option is to copy/paste one sheet's data to the bottom of the first
sheet's data and put a manual page break between them. Then print the first
sheet. Your duplex printer will then put the "first sheet's data" on one
side of the paper, and the other on the other side. HTH Otto
DJE said:
Ive created several sheets in Excel....now I want to have it printet on a
Click to expand...
duplex printer...so I want the 2 sheets to be on same paper...one on front
and the other on the back...
 
DJE said:
Ive created several sheets in Excel....now I want to have it printet on a
Click to expand...
duplex printer...so I want the 2 sheets to be on same paper...one on front
and the other on the back...
So far I havent found a solution...can anybody help me, plzzz ???
Click to expand...

Try this print utility, it will print 1-2-4-8 pages on one sheet, it is
quite versatile.
http://www.fineprint.com/products/fineprint/
Have a read at it's capabilities?
Scroll down to the free version, this prints a message on the bottom of each
page saying 'printed with FP from etc' & after 8 pages, but if you split up
your print jobs you can avoid the latter problem.
I would not be without it.
 
DJE
Have you tried selecting both sheets and then printing. When you do this Excel will treat the two sheets as a single print job. This usually causes me a headache because if you have page 1 of 1 as the footer for each sheet Excel will change it to 1 of 2 and 2 of 2. As long as your printer accomodates duplexing I think this will work

Select the first sheet and then, while holding the control key select the next sheet. Now you should see [Group] in the title bar at the top of your window. When your done be sure to click on another sheet to ungroup, otherwaise any change you make to one sheet will also be done to the other

Good Luck
Mark Graesse
(e-mail address removed)

----- Otto Moehrbach wrote: ----

AFAIK, Excel treats each Excel sheet as a separate print job. As such, you
only option is to copy/paste one sheet's data to the bottom of the firs
sheet's data and put a manual page break between them. Then print the firs
sheet. Your duplex printer will then put the "first sheet's data" on on
side of the paper, and the other on the other side. HTH Ott
DJE said:
Ive created several sheets in Excel....now I want to have it printet on
Click to expand...
duplex printer...so I want the 2 sheets to be on same paper...one on fron
and the other on the back..
 
Back
Top