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"

Find the data above the excel table, as shown below

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

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

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

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

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!