One of the easiest ways to organize or evaluate your data is to use Excel’s Sort feature. There are a couple of ways to control the sort—you can do a simple ascending or descending sort, or you can specify which data you want to sort and the type of sort you want to conduct.
Select the columns or the portions of columns whose contents you want to sort.
On the Data tab, click the Sort button to display the Sort dialog box.
Specify whether the data will be sorted A to Z, Z to A, or based on a custom list (alphabetic); or from smallest to largest, largest to smallest, or based on a custom list (numeric).
If you want to refine the sort by also sorting by a second column, click the Add Level button, and enter the search parameters. Repeat for any further level of search. You can use up to 64 levels in your search.
Click the Options button if you want to change to a case-sensitive sort for text or if you want to sort by rows instead of by columns.