ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/68563-sorting-excel.html)

acorrow

Sorting in Excel
 
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

Sorting in Excel
 
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

Sorting in Excel
 
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?


All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com