Printing a list in columns!

[JimC]

I have a list in Column in A of approx 135 items in sheet
1. (This will get bigger throught time) I would like to be
able to print this out sorted alphabetically and on a
landscape view were the list will also show up
alphabetically also but in several columns to fill the
page.
Is this possible to do via a macro or it a simple set-up
for print?
Help would be appreciated
Kind Regards
JimC

 

[Paul B]

Jim, have a look here
http://www.mvps.org/dmcritchie/excel/snakecol.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

 

[JiC]

Thanks Very much Paul B

-----Original Message-----
Jim, have a look here
http://www.mvps.org/dmcritchie/excel/snakecol.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **



.