Microsoft Office Tutorials and References
In Depth Information
Sorting by More than One Field
Figure 6–8. Choosing the fields by which to sort
The Sort On drop-down menu provides you four choices by which to sort— Values, Cell Color, Font
Color, and Cell Icon . Values denotes any data in the cell—and Values here also means text , not just
numbers. The next three options enable you to sort by cells whose appearances may have been changed
by a Conditional Format or even by standard formatting. Thus if you have a range of numerical data, and
you’ve Conditionally Formatted all the numbers in the range greater than 100 red, and all those less than
50 green, you can sort the green cells before the red (Figure 6–9):
Figure 6–9. Sorting by color. It’s done on more than just socks.
 
Search JabSto ::




Custom Search