How to set up automatic filtering in excel

How to set automatic filtering in excel: First open the excel table that needs to be set, and use the mouse to select any cell in the data area to be filtered; then switch the excel table to the data tab state of the ribbon And click the filter option in the Sort and Filter group; finally click the box in front of each value to check the value.

#First, open the excel table that needs to be set.

#Then use the mouse to select any cell in the data area to be filtered.

Then switch the excel table to the data tab state of the ribbon, and then click the filter option in the sort and filter group.

After clicking the filter button, the button will turn gray, indicating that it is selected, and then the excel area will become as shown in the figure below. An optional triangle box will appear behind the title bar.

After clicking the triangle box, you will see the menu bar as shown below, which displays all the deduplication values ​​under the title.

Click the box in front of each value to check the value. If you only want to display the data rows with the value "four", is it difficult? Juin is as shown in the figure As shown in, just check four.

Then, the data area will only display data rows with category four.

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