take a look he

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

In article ,
Sue wrote:

I have a long column of numbers that we add to daily. This column needs to
be sorted in ascending order and then printed. I don't know of a way to sort
multiple columns together so that is why it is one long column. Is there a
way to get it to print as multiple columns across a page so as to not have
numerous pages with only 1 column on each?
Thanks.