In addition to sorting, you may find that adding a filter allows you to better analyze your data. When data is filtered, only rows that meet the filter criteria will display, and other rows will be hidden. With data filtered, you can then copy, format, print, etc., your data, without having to sort or move it first. To use a filter,
You will notice that all of your column headings now have an arrow next to the heading name. Click on the arrow next to the heading by which you want to filter, and you will see a list of all the unique values in that column. Check the box next to the criteria you wish to match and click OK. Click on the arrow next to another heading to further filter the data.
To clear the filter, choose one of these options:
Watch the video for a demonstraton of the filtering techniques described above.
In the Sort & Filter Group of the Data Ribbon, there is an Advanced icon, which evokes the Advanced Filter dialog box. This dialog box allows you to set a particular criteria, copy results to another location (other location must be in the same sheet), and capture unique values.
For a quick sort, click the arrow below the Sort & Filtering icon in the Editing Group of the Home Ribbon and choose the Sort A to Z / Z to A icons in the Sort & Filter Group of the Data Ribbon. In Excel 2013, these are labeled Sort Smallest to Largest and the reverse.
For a more complex sort, go to the Home Ribbon, click the arrow below the Sort & Filtering icon in the Editing Group and choose Custom Sort. This takes you to the same Sort dialog box you get with the Sort icon in the Sort & Filter Group of the Data Ribbon.
1. In the Sort by pulldown, choose the first column by which you would like to sort. If you want to sort on multiple columns, click the Add Level button.
2. In the Sort On pulldown, choose how you would like to sort. Note that Excel can sort by cell or font color in addition to values.
3. In the Order pulldown, choose A to Z (ascending), Z to A (descending), or Custom List.
4. Click OK to perform the sort.