Everything at a glance with the “Data slice” visual filter in your pivot tables

Excel pivot table slicers replace complex filter menus with a clean, visual interface — large, coloured buttons that let you filter your data instantly and see exactly which criteria are active at a glance. To add a slicer, click inside your pivot table to reveal the PivotTable Analysis tab, then select Insert Slicer from the Filter command group. Choose the field you want to filter by — for example, Region — confirm, and the slicer panel appears on your worksheet, ready to use. Click any button to filter the entire pivot table immediately; click Remove Filter to reset. For multi-value filtering, either hold Ctrl while clicking or activate the Multi-Select button to select several criteria without a keyboard shortcut. To keep your interactive reports compact and professional, click the slicer border, open the Slicer tab, and set the number of columns in the Buttons group — this arranges your filter options side by side rather than in a long vertical list. Adjust colours via the Slicer Style gallery to match your report's design. If you remove the slicer panel entirely using the Del key, note that any active filter remains in place — clear it first via the filter icon in the field list if needed. The result is a dashboard-ready pivot table your audience can explore without touching a single dropdown or formula.