How do I arrange numbers in asending order in Excel?
 

I have a list of numbers and I need them in order from least to greatest.
How do I set the column of numbers to automatically be in order?

Select the range containing your data. Then click on DATA ... SORT ...
ASCENDING.

"Linds" wrote in message
...
I have a list of numbers and I need them in order from least to greatest.
How do I set the column of numbers to automatically be in order?

Select the column(s) then pulldown Data Sort... and sort ascending. Of
course this is a manual operation. If by automatically you want the column
re-sorted whenever a new value is added, then you would need an Event Macro.
--
Gary's Student


"Linds" wrote:

I have a list of numbers and I need them in order from least to greatest.
How do I set the column of numbers to automatically be in order?