| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create incremental numbers on an order form? | Excel Discussion (Misc queries) | |||
| reverse/manipulate order of numbers? | Excel Discussion (Misc queries) | |||
| How do I arrange worksheet tabs In alpha order | Excel Worksheet Functions | |||
| How do I arrange sheets in alphabetical order? | Excel Discussion (Misc queries) | |||
| How do I split a column having numbers and text in a random order | Excel Worksheet Functions | |||
Hybrid Mode
