What is a Slicer in Excel

A Slicer is an interactive control. A Slicer makes your job easy to filter data in a pivot table. The following figure shows a pivot table with three Slicers, their headings are: AcctType, OpenedBy, and Branch. Each Slicer is containing a particular field. In our example, the pivot table is displaying data for Savings account, Opened by New Accts at the Central branch.

Download this sample file to practice yourself

Bank-account-data.xlsx

Filtering Pivot Tables with Slicers in Excel

Showing a pivot table with three slicers. The data in the pivot table is filtered by these three slicers.

Filtering what we do with Slicers can be done by using the field labels in the pivot table, but Slicers are targeted for those who might not understand how to filter data in a pivot table. You can also use Slicers to create an attractive and easy-to-use interactive “dashboard”.

To add one or more Slicers in your worksheet, select any cell of your pivot table and then choose Insert ➪ Filter ➪ Slicer. The Insert Slicers dialog box will appear, with a list of all fields in your pivot table. Place a check mark next to one or more Fields, and then click OK.

Filtering Pivot Tables with Slicers in Excel.

Insert Slicers dialog box. This dialog box has the same fields when compared with the PivotTable Fields task pane.

New Feature: In Excel 2013, Slicers are no more limited to pivot tables. The slicer can also be applied to a table (created with Insert ➪ Tables ➪ Table). You can move and resize Slicers. You can change the look of Slicers too. Click the icon in the Slicer’s upper-right corner to clear filtering you have applied in the Slicer.

Happy Excelling 🙂

Read More…

How to Filter Excel Pivot Tables with Slicers!

What is a Pivot Table in Excel – Make a Pivot Table Manually!


Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share here. Not only how to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned!

We will be happy to hear your thoughts

      Leave a reply