David McRitchie has an answer for this exact question at this site

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



"Montrose Lyle" wrote:

> I frequently prepare lists in Excel that have one or two columns and many
> rows. I would like to have them print as many "snaked" columns as will fit
> on a page to reduce the number of pages that will print, similar to the
> multi-column format in Microsoft Word.
> --
> Lyle
> Montrose, Colorado
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...lic.excel.misc