Sorting

[John Dow]

I know how to sort a row of 2,000 random numbers. This
might take 40 pages if I only used one column per page.

???? How can I use and sort the full page (multiple
columns) where the date in column A line 50 would continue
to column C1? And c50 would continue on in E1 and so on?

Thanks in advance to the Excel expert.

 

[Dave Peterson]

Word does a nice job when you use Format|columns. It'll wrap things nicely.

Excel ain't much of a word processor. It's nice to create lists that keep going
down (to row 65536???).

I'd either keep the data in MSWord or keep it in Excel and when I wanted to
print, I'd copy|paste into Word and apply format|columns. (You can sort your
list in word, too.)

But if you must keep it in excel, I'd use a macro like David McRitchie's
snakecol right before I wanted to print it (publish it???).

I'd keep the raw data in nice columns going down the worksheet. It'll make
filters/sorts easier.

David's SnakeCols macro can be found at:
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