Sorting in Excel

A

acorrow

I have a huge list of file numbers in Excel - is there a way to sort them by
individual cell instead of by column or row?
 
J

Jim Cone

Do you want to sort the data from left to right or from top to bottom
so that your data would look like ?...

1 2 3 4 5
6 7 8 9 10

-or-

1 6
2 7
3 8
4 9
5 10

If so, you will have to create a macro or buy an inexpensive sort program.

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"acorrow" <[email protected]>
wrote in message
I have a huge list of file numbers in Excel - is there a way to sort them by
individual cell instead of by column or row?
 
Top