printing format

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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???
 
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.
 
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
 
Back
Top