Excel - Turn on Multiple Filters in a PivotTable

Posted on: 11/21/2022

Filter in PivotTables only allows one filter by default. To filter by more than one field, you need to turn on Allow multiple filters per field. To turn on, Allow multiple filters per field.

Right-click on a column in the PivotTable
Click PivotTable Options...
Click the Totals & Filters tab
Check to Allow multiple filters per field

Excel - filter by one column in the default

PivotTable Options - Allow multiple filters per field — PivotTable Options

YouTube Video

Teams training with Chris Menard

Teams online Training - 50% off coupon

Recent Articles

OneNote - SORT PAGES - New Feature - 2022

Previously, in OneNote, if you wanted to sort pages, you had to drag them around manually. Now, you can sort your pages in OneNote automatically!

3 AWESOME TIPS when working with OneNote & Outlook

Need to stay organized with Outlook? Use Microsoft OneNote and Outlook together. Three tips on working with OneNote and Outlook. Tip 1 - Insert your meeting invitation into OneNote. You can see a list of attendees and check that they attended, and take meeting notes.

Microsoft Word to Adobe Acrobat with Bookmarks

We don't usually want to email, or share are Word files. Frequently, we make our Word documents PDF files. If you lay out your Word document correctly, it is easy to make bookmarks in the PDF.

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Dictate in Word, Outlook, OneNote, and PowerPoint allows users to use speech-to-text to author content in files.