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 / New Users / December 2005

Tip: Looking for answers? Try searching our database.

Printing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Al - 14 Dec 2005 14:18 GMT
I have a worksheet with a single column of data (dvd list).  How can I get
it to print 2 or 3 columns to a page?
Max - 14 Dec 2005 14:59 GMT
> I have a worksheet with a single column of data (dvd list).  How can I get
> it to print 2 or 3 columns to a page?

Think Jim Cone has a nice Excel add-in "Side by Side" which could help you.
Try this post for details on how to reach Jim: http://tinyurl.com/9dwlv

Another play to try is to re-arrange the single source col
into several side-by-side cols
(then we could select the cols for printing or whatever)

Assume source list is in A1 down.
Let's say we want to re-arrange the source list into 3 side-by-side cols

Put in say, C1:
=INDEX($A:$A,ROW(A1)*3-3+COLUMN(A1))
Copy C1 across to E1,
fill down until zeros appear signalling exhaustion of data from col A

Adapt to suit ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
 
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.