ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Printing (https://www.excelbanter.com/new-users-excel/60366-printing.html)

Al

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?



Max

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
--




All times are GMT +1. The time now is 04:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com