How to Use Slicers in Excel

How to Use Slicers in Excel

Excel 2010 makes it possible to insert slicers to quickly and easily filter pivot tables. However, using the report filter gives the exact same result.

Below you can find a two-dimensional pivot table. Go back to Pivot Tables to learn how to create this pivot table.

Two-dimensional Pivot Table in Excel

To insert a slicer, execute the following steps.

1. Click any cell inside the pivot table. The PivotTable Tools contextual tab activates.

2. On the Options tab, insert a slicer.

Insert a Slicer

3. Check Category and click OK.

Check Category

4. For example, Click Fruit to only show the fruit exported to each country.

Slicer Example

Note: notice how the report filter changed to Fruit. Hold down CTRL to include fruit and vegetables.

Credit: http://www.excel-easy.com/examples/slicers.html

Leave a Reply

Your email address will not be published. Required fields are marked *