Excel QQ
#1
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.
Reply
#2
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.
Reply
#3
Use Data, then Sort
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)