Excel Pivot Tables Step by Step Tutorial

By Ted French, About.com Guide

Filtering the Pivot Table Data

The Pivot Table has built in filtering tools that can be used to fine tune the results shown by the Pivot Table.

Filtering data involves using specific criteria to limit what data is displayed by the Pivot Table.

Tutorial Steps:

1. Click on the down arrow next to the Region heading in the Pivot Table to open the filter's drop down list.
   
   
2. Click on the check box next to the Select All option to remove the check mark from all the boxes in this list.
   
   
3. Click on the check boxes next to the East and North options to add check marks to these boxes.
   
   
4. Click OK.
   
   
5. The Pivot Table should now show only the order totals for the sales reps that work in the East and North regions.

Previous

• Pivot Tables Overview
• Enter the Pivot Table Data
• Creating the Pivot Table
• Adding Data to the Pivot Table
• Filtering the Pivot Table Data
• Changing the Pivot Table Data

Next