Excel automatically filters, how to filter multiple values at the same time in customization?

Excel filters multiple values at the same time, which can be achieved by customizing multiple values through the filtering function.

The method comprises the following steps:

1. Open the EXCEL table to be operated, select the data column to be filtered, and then click the Data button in the toolbar.

2. Locate and click "Filter" in the data tab.

3. Click the inverted triangle filter button behind the first cell.

4. Select multiple values to filter as needed, and then click OK.

5. Return to the EXCEL table and find that Excel filters multiple values at the same time.