Excel® 2013 On Demand

Using Slicers to Filter a PivotTable

Instead of using the AutoFilter menu each time you want to filter data in a PivotTable, you can create a slicer button that enables you to quickly filter data in a PivotTable with a single click. Each slicer is shown on the screen with button labels that indicate the data being filtered. A slicer includes a header, filtering buttons, a Clear Filter button, a scroll bar, and move and resize controls. You can have more than one slicer and move them around on the worksheet. You can also format slicers with styles to match the look and feel of your worksheet and easily reuse them in other PivotTables, PivotCharts, and Online Analytical Professing (OLAP) Cube functions. If you have multiple PivotTables, you can ...