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 / Printing / April 2005

Tip: Looking for answers? Try searching our database.

Printing 2-up

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pierre Fichaud - 02 Apr 2005 15:44 GMT
I've got a 13 columns which I'd like to print 2-up, the first 50 rows on
the left side of a standard sheet of paper and the second 50 rows on the
right side and so on for the next 100 rows. TIA. PF.
David McRitchie - 02 Apr 2005 21:06 GMT
Hi Pierre,
There is no provision for this in Excel.  (You can do this in Microsoft Word)
You can do this with the help of a macro in Excel or an addin
Macro solution on my page:
  http://www.mvps.org/dmcritchie/excel/snakecol.htm#snakecols

To show 13 columns of data, printing portrait you will probably only be able
to fit about 3 characters of data per column with a appropriate 2 characters of
spacing between columns, if you want to print to 13 columns (25 columns total)
unless you print landscape.

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

> I've got a 13 columns which I'd like to print 2-up, the first 50 rows on
> the left side of a standard sheet of paper and the second 50 rows on the
> right side and so on for the next 100 rows. TIA. PF.
 
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



©2008 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.