Tip:
Highlight text to annotate it
X
Sort a Range.
You can make a range easier to read and easier to analyze by sorting the data based on the
values in one or more columns. You can sort the data in either ascending or descending
order. An ascending sort arranges the values alphabetically from A to Z, or numerically
from 0 to 9; a descending sort arranges the values alphabetically from Z to A, or numerically
from 9 to 0.
Click any cell in the range you want to sort.
Click the Data tab.
Click Sort arrow.
Click Custom Sort.
The Sort dialog box appears.
Click the Sort by and then click the field you want to use for the main sort level.
Click the Order and then click a sort order for the field.
To sort on another field, click Add Level icon.
Excel adds another sort level.
Click the Then by and then click the field you want to use for the sort level.
Click the Order and then click a sort order for the field.
Repeat this Steps to add more sort levels as needed.
Click OK.
Excel sorts the range.