top of page

Use Excel Slicers to Filter Pivottable data

Excel Tip: Use a Pivot Table Slicer if you want to filter data in a Pivot Table. You can quickly change the filter criteria by clicking on the slicer buttons, without having to open the drop-down menus or use the filter dialog box. An example of a slicer is shown below where I am filtering on Sales Rep. On the left side is data for all the sales reps. On the right side I filtered data for Vicki Jones.

Contact me at or 561-289-9484 for support on creating Pivot Table Slicers. Whether you need advice on cleaning up your Excel data, creating formulas or solving formula issues, count on me!

Recent Posts

See All


bottom of page