Microsoft Office Tutorials and References
In Depth Information
Sorting by Multiple Parameters
FIGURE 21.6 Data Sorted by Age within the Gender Sort
FIGURE 21.7 Sorting through the Home Ribbon Icon
FIGURE 21.8 Right-Click or Use a Shortcut, Shift
cell colors. Figure 21.8 illustrates starting the sort by color. Figure 21.9 shows how to
add levels and sorting the data by cell colors. The color option is under Sort By as
illustrated in Figure 21.9.
Note how, in Figure 21.10 the data is sorted by color.