How To Insert a Pivot Table Slicer | MyExcelOnline

Slicers in Excel are visual filters or interactive buttons that allow you to see what items have been chosen within a Pivot Table.

They are a new feature from Excel 2010 onward and Mac for Excel 2016 and a must for anyone wanting to wow their boss by adding interactivity in their reports!  I show you how to insert a Pivot Table Slicer below:

 

How To Insert a Pivot Table Slicer | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Select your Pivot Table by clicking anywhere inside it.

How To Insert a Pivot Table Slicer | MyExcelOnline

 

STEP 2: Go to Options(Excel 2010)/Analyze(Excel 2013&2016) > Insert Slicer 

Select the Month and Year Fields.

Click OK.

How To Insert a Pivot Table Slicer | MyExcelOnline

Your slicer is now ready!  Go crazy clicking, slicing and dicing your data!

TIP: Hold down the CTRL key to select multiple items in your Slicer.

How To Insert a Pivot Table Slicer | MyExcelOnline

How To Insert a Pivot Table Slicer:

 

Helpful Resource:

How To Insert a Pivot Table Slicer | MyExcelOnline

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

How To Insert a Pivot Table Slicer | MyExcelOnline