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?

not sure what you mean, but you can highlight a range of cells and sort just
that

"acorrow" wrote:

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?

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"
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?