Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spread few colunm data across single page.
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spread few colunm data across single page.
On 10 May, 20:54, Dax Arroway
wrote: 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 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....htm#snakecols HTH Andrew |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spread few colunm data across single page.
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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page numbers on copies of a single page worksheet | Excel Discussion (Misc queries) | |||
Printing multiple page worksheets on 1 single page | Excel Discussion (Misc queries) | |||
Print a custom page from scheduling data in a single row | Excel Discussion (Misc queries) | |||
How do I print a single column of data in two columns on one page | Excel Discussion (Misc queries) | |||
How do I rotate a spread sheet to fit on page vertically? | Excel Discussion (Misc queries) |