2. Drop-down arrow: after automatic filtering is selected, a drop-down arrow will appear in the data column, and a filter menu will appear after clicking the drop-down arrow. Each drop-down menu corresponds to a screening classification.
3. Filtering Method: For table files containing a large amount of data, click "Digital Filtering" to filter specific data or data within a certain numerical range. For example, if you need to filter out items with historical scores below 85, click the number filter, select less than, and then enter 85 to filter.
4. Establishment area: If you want to screen out students with more than 80 points in multiple categories, such as four courses, you need to establish a conditional area in advance, leaving three or more lines above the whole data, corresponding to the input data classification and the required conditional restrictions respectively.
5. Advanced Filtering: Click on the menu bar-Data-Filtering-Advanced Filtering to open the advanced filtering menu.
6. List area and condition area: After opening the advanced filter, you can enter the cell range or check the required area with the mouse, and check the list area and condition area respectively.
7. Get results: If the filtered data needs to be displayed separately in other places, check Copy the filtered results to other places, and manually click the cell to be stored.
Click OK to get the filtering results.