Shulou(Shulou.com)06/03 Report--

How to use WPS tables for data filtering? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

The WPS table uses the method of data filtering: first, open the table and click on the data, select automatic filter from the menu that appears; then select the entire table and select automatic filter, and finally click on the small triangle after the date to filter each data.

The first step is to open the table, click data, and select Auto filter from the menu that appears, and a dialog box appears that says that the WPS table cannot use the specified area to complete this command. Please select more cells in the range, and then try this command again.

The second step, now select the entire table, and then select automatic filter, then you will find that there will be a certain drop-down triangle in the cell of each header.

The third step, click on the small triangle after the date, a dialog box will appear according to the date of 11 different choices, so that you can view the amount of concrete on different dates.

In the third step, click on the small triangle behind the use part, and you can see different choices such as panel wall, independent foundation, negative top and so on, so that you can see the amount of concrete in different parts.

Step 4, now let's sift through the concrete data of the wall beam-slab columns on June 20, 2018. First click on the date, click on the selected small box, remove the check mark of all selected money, and then click the small box before 6.20 with the mouse, then the data in the table is only 6.20.

The fifth step, at this time, click on the use site, remove all the selection, and only select the wall beam plate column, at this time the data is the concrete data of the wall beam-slab column on June 20.

This is the answer to the question on how to use the WPS table for data filtering. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.