column snaking print format

[Guest]

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/com...1-efe0cf0427a7&dg=microsoft.public.excel.misc

 

[David McRitchie]

Hi Lyle,
To read about installing and using macros see
Getting Started with Macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm

I have such a reference at the top of most of my pages with macros,
I'll fix that omission.

Since you mention 9 pages, the specific area you want to read the most is
Attempting to Snake columns using Excel (#snakecols)
http://www.mvps.org/dmcritchie/excel/snakecol.htm#snakecols

 

[Dave Peterson]

Maybe copying and pasting into MSWord and then using that would be sufficient.

In fact, if the list is plain old text, maybe keeping that list in MSWord would
make more sense.