Microsoft Office Tutorials and References
In Depth Information
USE AUTOFILTER WITH A PIVOT TABLE
USE AUTOFILTER WITH A
Challenge: You’ve created a pivot table to summarize sales by customer. You
now want to ﬁ lter those results to show only the customers with sales between
$20,000 and $30,000. The AutoFilter command is grayed out for pivot tables.
Solution: You can fool Excel into turning on the AutoFilter dropdowns by
starting your selection one cell to the right of the pivot table headings. In Figure
67, select cell E4. Hold down the Shift key and press the left arrow key four
times to select E4:A4.
Figure 67. Start your selection just to the right of the pivot table headings.
In Excel 2003, you can select Data, Filter, AutoFilter to turn on the AutoFilter
dropdowns. In Excel 2007, choose the Filter command from the Data tab.
Figure 68 shows how you apply a custom ﬁ lter to limit the customers to those
with sales between $20,000 and $30,000.
Figure 68. Use the i lter
dropdowns on the pivot