How do I arrange numbers in asending order in Excel?

L

Linds

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

Lewis Clark

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

Gary's Student

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.
 
Top