How to filter more than 3 keywords at the same time in excel

php editor Apple brings you tips on how to filter more than 3 keywords in Excel at the same time. In Excel, filtering data is a common operation, but it may be a little confusing when you need to filter multiple keywords. This article will introduce in detail how to filter more than 3 keywords at the same time in Excel, allowing you to quickly and accurately find the data you need.

The first method is to gradually add the conditions to the filter. If you want to filter out three qualifying details at the same time, you first need to filter out one of them step by step. At the beginning, you can first filter out employees with the surname "Wang" based on the conditions. Then click [OK], and then check [Add current selection to filter] in the filter results. The steps are as follows.

　

Similarly, filter employees with the surname "Li" and "Zhang" again, and check [Add current content to filter] respectively, and finally Complete filtering. The details are shown in the figure.

　

The core point of filtering is that when filtering, after adding the selected content to the filter, the filtered content will be retained, so that each pair can be completed in one go Filter more than three conditions in a single column. The details are shown in the figure.

Method 2: Advanced filtering. Advanced screening methods can also be used for the above problems, as follows. Step 1: In the blank area, prepare the title and conditions of the content to be filtered.

Click [Data]-[Advanced], in the pop-up dialog box, select [Show filter results in the original area], then frame the data, and finally click [OK]. The details are shown in the figure.

　

Both of the above two methods can ultimately achieve our goal. You can choose whichever you prefer, but the editor recommends that you first use it on the computer. Try both methods step by step according to the above steps, so that you will know which one is more suitable for you.

The above is the detailed content of How to filter more than 3 keywords at the same time in excel. For more information, please follow other related articles on the PHP Chinese website!