Slicer Option

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

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.
  3. Check Category and click OK.

One thought on “Slicer Option

  1. You have identical sense …

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>



clearPost Comment