Printing Multiple pages one one page

[Guest]

I have an excel document that is 4 pages long but only a few columns wide.
When I print the spreadsheet it's long, but wastes so much paper? How can I
make it so that all four pages prints one one page?

 

[Guest]

the simplest way is to make a page specifically for printing where you wrap
the columns in one page.

 

[Dave Peterson]

I like to copy the data into MSWord and use MSWord's builtin ability to do
column layout. With lots of data, I sometimes have to paste into Notepad
first--large tables cause me trouble in MSWord.

If that doesn't work for you, David McRitchie has a macro that will "snake" the
columns.
http://www.mvps.org/dmcritchie/excel/snakecol.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm