Spread few colunm data across single page.

D

Dax Arroway

I've got simple data (a list of names and dates (Col A=Names, Col B=Dates,
it's a report) that stretches over 4 pages. When I print it, I get the names
and addresses as they should be but they're just one column going down the
left side of the page. Is there a way of making this column break to create
4 columns and connect from one to the next to the next accross the page so I
get 4 columns of names and dates all on one page? In word you set up a
section break and then create columns. I'm trying to do that function, but
in excell. Is there a way?

I've tried searching on this but can't find anything and honestly, I don't
even know if I'm searching for the right keywords.
- Dax
 
L

loudfish

I've got simple data (a list of names and dates (Col A=Names, Col B=Dates,
it's a report) that stretches over 4 pages. When I print it, I get the names
and addresses as they should be but they're just one column going down the
left side of the page. Is there a way of making this column break to create
4 columns and connect from one to the next to the next accross the page so I
get 4 columns of names and dates all on one page? In word you set up a
section break and then create columns. I'm trying to do that function, but
in excell. Is there a way?

I've tried searching on this but can't find anything and honestly, I don't
even know if I'm searching for the right keywords.
- Dax
Click to expand...

This is something Excel is dreadful at. You can get this to work the
VBA - have a look at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/snakecol.htm#snakecols

HTH

Andrew
 
J

Jim Cone

You can paste into Word and use Format | Columns
-or -
build your own method (see the link that loudfish posted)
-or -
use a commercial application... "Side by Side" from your truly at...
http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA


"Dax Arroway" <[email protected]>
wrote in message
I've got simple data (a list of names and dates (Col A=Names, Col B=Dates,
it's a report) that stretches over 4 pages. When I print it, I get the names
and addresses as they should be but they're just one column going down the
left side of the page. Is there a way of making this column break to create
4 columns and connect from one to the next to the next accross the page so I
get 4 columns of names and dates all on one page? In word you set up a
section break and then create columns. I'm trying to do that function, but
in excell. Is there a way?

I've tried searching on this but can't find anything and honestly, I don't
even know if I'm searching for the right keywords.
- Dax
 
Top