Microsoft Office Tutorials and References
In Depth Information
Finding What You Want with Filters
NOTE: What about the Copy Level button? If you click Copy Level on a field in the dialog box,
that same field will be instated again in the Sort dialog box. That’s right—the same field will
appear twice. But how can you sort the same field twice?
Again, the answer takes us back to conditional formats. If, say, you wanted to sort the
database by Salary in largest-to-smallest direction, and at the same time you conditionally
formatted the data so that some of the Salary cells turned red and others didn’t (for whatever
reason), you could instruct Excel to sort the red $50,000 cells before the uncolored $50,000
cells in that copied level. (No, you’re not likely to use this one.)
Finding What You Want with Filters
In the introduction of this chapter I pointed out that a great deal of the work people do
with databases involves asking questions of a database’s records; questions whose
answers are usually supplied by just some of the records—such as which people in the
company earn more than $50,000, or who works in the Sales department. Excel offers a
very easy way to ask and answer these kinds of questions—through its filter feature.
Filters have been around in Excel for quite some time, but they’ve been improved,
without compromising ease of use—as you’re about to see.
To begin filtering your
data, just click anywhere
in your database, and then
click the Filter button in the
Data tab’s Sort & Filter
button group (see Figure
Figure 7–10. Where to start the filtering process
Click the Filter button and you’ll see the results from Figure 7–11.
Search JabSto ::

Custom Search