printing format

[Guest]

hello
probably quite simple, but, i have a pivot table, very, very long, but very thin, obviously this prints out on about 10 pages as a very long table
is there any way i can just repeat the columns and stick it on one page

i.e its like thi
fruit no
apple
apple
apple
apple
apple
apple
apple
apple
apple
apple
apple
apple
apple
etc.

and i'd like it to look like thi

fruit no. fruit no. fruit no. fruit no
apple 1 apple 2 apple 4 apple
apple 3 etc

hope you get the message and i think this is the longest problem posed so far

t

 

[Dave Peterson]

How about copying that range into MSWord and using Word's built in features.

Format|Columns|...

Then print it, pick up your listing and toss the word file--it's out of date as
soon as it hits paper???

 

[Guest]

Hello
cheers for the idea, its a bit fiddly though and doesn't really work, is there any other way. its amazing that you have programs like Excel that can do tons of hard stuff, yet, transforming 1 long thin column into a few shorter ones doesn't seem to happen

gadzooks.

 

[Dave Peterson]

Not quite sure why it didn't work in word, but David McRitchie has a "snakecols"
routine that you could use:

http://www.mvps.org/dmcritchie/excel/snakecol.htm

David also has instructions for MSWord on that same web page. You may want to
try it once more.

 

[Gord Dibben]

Nathan

How do you want your end product to be formatted?

e.g. if you had 1200 rows in one column.....would you want 6 columns of 200
each snaked top to bottom to top to bottom etc?

OR 6 columns of 1-50, 51-100, 101-150 etc. in 4 groups of 300?

There are different codes for different formats.

BTW Excel was designed and coded as a number cruncher first, not a word
processing application.

It would be nice if Excel had a "column" feature but.........

Gord Dibben Excel MVP