Microsoft Office Tutorials and References
In Depth Information
Sorting by Multiple Parameters
SORTING BY MULTIPLE PARAMETERS
If you wish to sort by more than one parameter, you have to use the Sort dialog box.
For example, should you want to sort by gender and by age within the gender,
follow the example in Figure 21.5.
In the dialog box, you have to select the Sort by cell and select the column header
you want the sorting to occur in. Then, under the Sort On category, choose the type
of sort you want to use (value, color, and so on). The third drop-down menu allows
you to choose whether you wish to apply ascending or descending sorting. Click on
Add Level when you want to add the secondary sorting parameter/header. The
secondary level implies that this sorting will occur within the first sorted category.
You may continue this way with more headers, up to a maximum of three.
Notice how, in Figure 21.6 the ages are sorted within the gender. You may sort,
using this function, by up to three parameters, in ascending or descending order.
More about Sorting
There are two more ways to access the sort features in Excel. One way is through the
Home ribbon. On the right side of the ribbon you will see the Sort and Filter icon. See
Another way is to right-click after selecting a cell or to use a shortcut for right-
F10. The local menu allows you to use the sort features as you can see in
Sort by Color in Excel 2010 and 2007
Since 2007 Excel has a new feature that allows you
by color or format. On the sheet named Colors, you can try and sort the data by
color. When you click on the Sort icon, you can proceed with sorting the data using
among other features
FIGURE 21.5 Sorting by More than One Parameter