Home  >  Article  >  Software Tutorial  >  How to use slicer in WPS_How to use WPS slicer

How to use slicer in WPS_How to use WPS slicer

WBOY
WBOYforward
2024-04-24 12:40:36500browse

The built-in slicer function in WPS tables can help users quickly analyze and filter out the required information from massive data, greatly improving work efficiency. In this article, PHP editor Baicao will introduce in detail how to use the WPS slicer, including how to insert, configure and use the slicer, so that everyone can easily master this practical data analysis tool. The following are the specific steps:

The first step is to open the table on our computer that we want to use the pivot table slicer.

How to use slicer in WPS_How to use WPS slicer

The second step is to click on the pivot table and in the analysis interface, click on Insert Slicer.

How to use slicer in WPS_How to use WPS slicer

The third step is to enter the interface for inserting a slicer, check the fields that need to generate a slicer, and generate a slicer for each field.

How to use slicer in WPS_How to use WPS slicer

The fourth step, after clicking OK, you can see that the slicer has been inserted into the table. By default, all are checked, so all the data is filtered.

How to use slicer in WPS_How to use WPS slicer

The fifth step is to click on a row on the slicer. You can see that the data in the pivot table has been filtered. The slicer mainly plays the role of filtering the data.

How to use slicer in WPS_How to use WPS slicer

Step 6. If we want to select multiple items in the slicer, we can hold down the ctrl key or shift key to select.

The above is the detailed content of How to use slicer in WPS_How to use WPS slicer. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete