Excel's 'sort by row function'

  • Thread starter Thread starter virfir97
  • Start date Start date
V

virfir97

X-No-Archive

Please help

I have various large ranges in which I wish to sort each row
individually into numerical order. But Excel's 'Sort by row function'
only does one row at a time

Which method can I use to sort many rows into numerical order?

Thanks.
 
Vir,

I think you want each individual row put into consecutive order, left to
right, without regard to any other row. If so, you'll have to select the
rows one at a time, and do a sort on each. The quick-sort toolbar buttons
are wired to sort only vertically, so they won't do. You'll have to use
Data - Sort. Any sort command is likely to result in "Excel found data next
to your selection..." You should opt not to expand the selection, but to
continue with the current selection. In the Data - Sort dialog, use
"Options" and opt for left-to-right sorting, as I think you're doing. A
macro could automate this.

Another possible solution is formulas in a separate table to present the
data as you want.
 
Back
Top