+- Southperry.net (https://www.southperry.net)
+-- Forum: Social (https://www.southperry.net/forumdisplay.php?fid=14)
+--- Forum: Shenanigans (https://www.southperry.net/forumdisplay.php?fid=51)
+--- Thread: Excel QQ (/showthread.php?tid=3691)
Excel QQ - butterfλi - 2008-09-24
anyway i need halp with excel. say you have a list of numbers in a bunch of cells like
| 6 |
| 3 |
| 5 |
| 2 |
| 4 |
| 1 |
etc. how do you get it so that excel organizes those numbers numerically? basically make that look like:
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
or
| 6 |
| 5 |
| 4 |
| 3 |
| 2 |
| 1 |
without having to do it manually.
Excel QQ - Corn - 2008-09-24
Highlight the data and space above it.
Then go to data>>>>filter>>>autofilter.
On the empty space, there should be a arrow pointing down. Hit it and say "sort descending or ascending."
Well, I'm sure there's an easier way, but that's how I do it.
Excel QQ - apathy - 2008-09-24
Use Data, then Sort