Excel Hints & Tips – Slicers

MS ExcelSlicers

In his blog on Pivot Perfection, Darren showed us how to easily produce a series of Pivot Tables for each category we want to filter on. Slicers make it easy to have one Pivot Table that can switch between different categories.

Let’s start with the same data that Darren used:

Pic 1

The next step is to add a Slicer:

  1. Go to the Options tab of the PivotTable Tools on the ribbon
  2. Click on Insert Slicer

Pic 2

3. Choose the field you want to filter on, in this case Department

Pic 3

4.  Click OK

5.  A Slicer box will appear on your worksheet:

Pic 4

6.  Click on the category you are interested in, for example, the Design department

7.  The Pivot Table will update to show the values for that category:

Pic 5

8.  To change to a different category, just click on the appropriate value in the slicer box

9.  To select multiple values, do a normal click on the first value, then control-click on the other values:

Pic 6

10.  To clear the filter, click on the icon in the top-right corner of the Slicer box

Pic 7

11.  You can move and re-size the Slicer box by clicking and dragging on the border of the box

This blog was written by Happy Trainer, Ian Balboa.


 

If you have any Excel questions or hints and tips you would like shared get in touch, use this link!

If you would like any further information on the Excel course we train, go to our dedicated Excel page on our website. If you are unsure of your Excel level, take our handy Excel survey.

Remember – If you’ve been on a Happy Computers course you get 2 years free helpline access.  Call the helpline on 020 7375 7373.

Happy Computers

 

Leave a Reply

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