Select Page

Excel Video 284 shares an easy way to filter your Pivot Table data. There are several ways to filter, or limit the amount of data in your Pivot Table. Today we’ll discuss the easiest way to filter, simply by checking boxes. I call this way of filtering a manual filter because you manually check and uncheck the items you want in your Pivot Table. Manual filters work for both the fields in the Row Labels and Column Labels areas and for fields in the Report Filter area. Watch how I check the Select Multiple Items box so that you can choose more than one item to filter by in the Report Filter area.
Manual filters work great when you have a few items to choose from. If you have a bunch of items to choose from, there are several other ways to filter data besides checking a long list of boxes. We’ll start talking about other ways to filter data in the next Excel Video. I look forward to seeing you then.