Click column number B in the second column, select column B, select the 'Data' tab, click the 'Filter' icon, then a filter icon in the lower right corner of the cell B1, click the icon, Select 'Number Filters' → Top 10 in the pop-up menu, open the 'Top 10 AutoFilter' dialog, click 'OK' to automatically filter out the top 10 in the same way, open the 'Top 10 AutoFilter' dialog and change 10 to 3, click 'OK', the first 3 are automatically selected the first 5 filters are the same method the operation steps are as shown in Figure 2:ī. If you want to filter the top 3, 5, and 10 of the 'Advanced Mathematics' scores. Right-click one of the cells with a score of 684(such as B2), select 'Filter' from the pop-up menu, and select 'Filter by Selected Cell's Value' in the expanded sub-option, and filter all students whose scores are 684 points steps of the operation process, as shown in Figure 1:Ī. Suppose you want to filter all students whose score is 684.

How to filter out duplicates in excel(Filter by Selected Cell's Value) The filtered operation can be done with both the mouse and shortcut.ġ. There are also two combinations of conditions, one bases on option and the other uses wildcard.

In addition to filtering by one condition, it can also filter by two conditions, and can also filter multiple columns at the same time. Excel filter is divided into five categories, namely number filter, text filter, cell color filter, font color filter and cell icon filter. There are two ways to filter in Excel, one is to use the 'Filter' in the right button menu of mouse to quickly filter, and the other is to use the options in the 'Filter' drop-down menu to filter.

Excel shortcut keys filter