Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / December 2005

Tip: Looking for answers? Try searching our database.

Excel - print 2 pages on 1 sheet of paper

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jerome - 20 Dec 2005 19:02 GMT
In Excel I made a product list containing 4 colomns and over 1000 rows. When
I print it I only use half the paper. I'd like to be able to put page 2 next
to page 1 on the same sheet of paper. Who can help?
Tom Ogilvy - 20 Dec 2005 19:12 GMT
The easiest solution would be to check your print driver's capabilities and
see if it will support 2 UP printing (2 pages per sheet).  If it has a post
script driver, it should be able to do this.

Signature

Regards,
Tom Ogilvy

> In Excel I made a product list containing 4 colomns and over 1000 rows. When
> I print it I only use half the paper. I'd like to be able to put page 2 next
> to page 1 on the same sheet of paper. Who can help?
Gord Dibben - 20 Dec 2005 21:04 GMT
Jerome

Can you deal with a macro?

This macro will move rows 50 to 100 up to E1:H50 and repeat to end of data in
the four original columns.

Leaves a blank row between each set of 50 rows.

Sub Move_Sets4_8()
Dim iSource As Long
Dim iTarget As Long
   iSource = 1
   iTarget = 1
   Do
       Cells(iSource, "A").Resize(50, 4).Cut _
       Destination:=Cells(iTarget, "A")
       Cells(iSource + 50, "A").Resize(50, 4).Cut _
       Destination:=Cells(iTarget, "E")
       iSource = iSource + 100
       iTarget = iTarget + 51
   Loop Until IsEmpty(Cells(iSource, "A"))
End Sub

Gord Dibben Excel MVP

>In Excel I made a product list containing 4 colomns and over 1000 rows. When
>I print it I only use half the paper. I'd like to be able to put page 2 next
>to page 1 on the same sheet of paper. Who can help?
Jerome - 20 Dec 2005 21:30 GMT
Thanks! That works perfect.

> Jerome
>
[quoted text clipped - 25 lines]
> >I print it I only use half the paper. I'd like to be able to put page 2 next
> >to page 1 on the same sheet of paper. Who can help?
Gord Dibben - 20 Dec 2005 23:09 GMT
Thanks for the feedback.

Gord

>Thanks! That works perfect.
>
[quoted text clipped - 27 lines]
>> >I print it I only use half the paper. I'd like to be able to put page 2 next
>> >to page 1 on the same sheet of paper. Who can help?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.