If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Printing
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? |
#2
|
|||
|
|||
Printing
"Al" wrote in message ...
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 -- |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Publisher and HP 6540 borderless printing | Wildfire563 | Publisher | 10 | September 8th, 2005 06:31 PM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Printing from Word | [email protected] | New Users | 1 | January 28th, 2005 12:57 AM |
How do I get colour separated printouts red and black? | Karen | Publisher | 2 | November 27th, 2004 11:14 PM |
PPoint 2003 Slow Automation printing | Ron James | Powerpoint | 3 | July 28th, 2004 07:39 PM |