Sorting in Excel

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

[dlw]

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?

[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" <acorrow@discussions.microsoft.com>
wrote in message
news:5CF76712-431C-4527-BDF4-4E19F6CF00B7@microsoft.com...
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?