Home>Article>Topics> How to do automatic filtering in excel table

How to do automatic filtering in excel table

藏色散人
藏色散人 Original
2020-03-05 08:46:51 7582browse

How to do automatic filtering in excel table

How to automatically filter excel tables?

Find the table that needs to be filtered on the computer, as shown below

Recommended: "excel tutorial"

How to do automatic filtering in excel table

Find the data above the excel table, as shown below

How to do automatic filtering in excel table

Use the mouse to select the entire table, as shown below

How to do automatic filtering in excel table

Click the data with the mouse to find the automatic filter, as shown below

How to do automatic filtering in excel table

Use the mouse to click on the automatic filter, and you will see a triangle under the first row of the table, as shown below

How to do automatic filtering in excel table

Use the mouse to click on the triangle under the sales volume, and then select For the data that needs to be filtered, click OK to complete the filtering, as shown below

How to do automatic filtering in excel table

How to do automatic filtering in excel table

The above is the detailed content of How to do automatic filtering in excel table. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn