Chapter 7
Sorting and Filtering Data
Perform a Simple Sort or Filter
You can make a range easier to analyze by sorting it based on a column’s values. You can sort the data using either an ascending sort, which arranges the values alphabetically from A to Z or numerically from 0 to 9, or a descending sort, which arranges the values from Z to A or from 9 to 0.
You can also analyze data by filtering it to show only the items you want to work with. The easiest way to filter a range is to use the Filter buttons, each of which presents you with a list of check boxes for each unique value in a column. You filter the data by activating the check boxes for the items you want to see.
Perform a Simple Sort or Filter
Sort a List
Click a cell in the ...
