WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to use Slicers to filter pivot tables in Excel

January 6, 2022
6.3K Views

Pivot Tables is a powerful feature used to design dynamic charts and extract significant information from a complex data set. And we can use Slicers to filter pivot tables to create awesome worksheets.

Suppose we have a set of data illustrating the sales of a coffee brand in different countries in 2021. Here are the steps.

1.  Go to the Insert tab and click the Slicers button. In the pop-up dialogue box, select the check boxes for the fields you want to display and click OK.

2. You can click the slicer as needed and select a slicer style in the Slicer Tools tab. For example, if you want to find out in which country Americano sells best, click Americano. Similarly, you can select other fields for more details.

If you want clear the filter, click the Clear Filter button and choose other fields again.

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.