Microsoft Office Tutorials and References
In Depth Information
Sorting worksheet data
Home tab. Then, in the Editing group, in the Sort & Filter list, click Sort Largest To Smallest.
Clicking Sort Largest To Smallest makes Excel put the row with the highest value in the
Revenue column at the top of the worksheet and continue down to the lowest value.
If you want to sort the rows in the opposite order, from the lowest revenue to the highest,
select the cells in the Revenue column and then, in the Sort & Filter list, click Sort Smallest
TIP The exact set of values that appears in the Sort & Filter list changes to reflect the data
in your column. If your column contains numerical values, you’ll find the options Sort
Largest To Smallest, Sort Smallest To Largest, and Custom List. If your column contains text
values, the options are Sort A To Z (ascending order), Sort Z To A (descending order), and
Custom List. And if your column contains dates, the options are Sort Newest To Oldest, Sort
Oldest To Newest, and Custom List.
By using the Sort Smallest To Largest and Sort Largest To Smallest options, you can sort
rows in a worksheet quickly, but you can use these options only to sort the worksheet
based on the contents of one column, even though you might want to sort by two columns.
For example, you might want to order the worksheet rows by service category and then by
total so that you can display the customers that use each service category most frequently.
You can sort rows in a worksheet by the contents of more than one column by using the
Sort dialog box, in which you can pick any number of columns to use as sort criteria and
choose whether to sort the rows in ascending or descending order.