Sorting: Your basic everyday sorting
In the mood of fall cleaning and to celebrate having gotten my office organized, I'm going to blog this week about sorting. Today, it's just basic run-of-the-mill sorting using the sorting icons on the toolbar.
Let's say you've just got this list, and you want to sort it alphabetically.
Select it, without selecting any data you don't want sorted.
Click either the A-Z or Z-A icon.
You get your results.
Be sure not to select any headings, i.e. the word Employee in this case, or you get this result, which you don't want.
What if you have something like this, though? Something with multiple columns.
Here's the thing. Selecting, say, the 2000 column and clicking a sort icon will NOT give you good results. It will sort just the data in the 2000 column and leave all the other data behind. So all of a sudden your data is wrong.
You cannot specify the column to sort by, using the simple sort icons. That's covered in my next blog entry on sorting.
Here's what you can do. You can sort by the first column in the data set. You select ALL the data, again without the headings.
You click the sort icon you want.
And you get your results; the data is sorted by the first column. That's your only choice.
If you had selected just one column, the data would be goofed up. 
For more control over sorting, tune in for the next sorting blog.
Comments