Sorting 4 columns as one

[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.

 

[David McRitchie]

Hi John,
Excel has very limited facilities for saving paper (fit to page, font, margins).

You will have to maintain your sheet as the 3 columns and snake
that into another sheet for display and / or printing. See

SNAKECOLS, How to snake columns to use fewer pages
http://www.mvps.org/dmcritchie/excel/snakecol.htm

 

[Jim Cone]

John,

I wrote an Excel add-in ("Side by Side") to rearrange long columns of data,
so as to reduce the number of printed pages; sounds like it could meet your needs.
It changes the specified column(s) into a 2-up, 3-up or 4up arrangement.
Data sequence is maintained and the area above the data remains unchanged.
Your original worksheet is not affected as a new worksheet is created
with the new column arrangement.
Comes with a one page Word.doc install/use file.
Available - free - upon direct request. Remove xxx from my email address.

Regards,
Jim Cone
San Francisco, CA

(e-mail address removed)