1
Select the original data area (including the title), and then click Data-Filter.
When the operation is completed, a drop-down arrow will be generated for each cell in the first row (looking up) of the data area.
Click an upward-looking drop-down button, and you can see that there are three sorting functions at the top, namely "ascending", "descending" and "sorting by color". We can use this function to sort the data first.
Click the Select All button in the selection box below to select everything. You can also cancel the select all status directly and manually select the data to be filtered with the mouse. For example, we only need Chen Yu, Li Qiuxiang and Qin Qin.
After clicking OK, the table will only show the data of Chen Yu, Li Qiuxiang and Qin Qin. The rest of the data will be hidden automatically. The line number will be displayed in blue, indicating that automatic filtering has been performed.
When we click on the text filter, we can see the optional menus at the next level, such as "contains", "does not contain", "equals" and "starts with". We may need to choose specific content.
For example, we choose "contain". Enter the word "small" after the inclusion, and then click the OK button. In this way, all names containing the word "small" will be filtered out.
You can choose two conditions here, and the relationship between the two conditions is "meet at the same time" or "meet one of them". Represented as AND and OR in the filter. We choose "or", and in the second condition drop-down menu, we also choose "including" and then enter the word "jade".
In this way, all the names containing the word "Xiao" or "Yu" have been screened out.
Let's select the date drop-down button in the first column to see what functions Excel has in filtering dates.
The first difference you can see is that Excel automatically classifies dates and groups them by year, month and day. It is convenient to select year or month data.
Click the date filter button to see more abundant date filter options.
Note: In order to use the powerful function of automatic filtering for date filtering, you need to ensure that the date is in a date format that Excel can recognize, not in a text or unrecognized date format.