How to find all matches at once in Excel

Let’s take a look.

In this case, there are 19 cells that match the search forAnn.

it’s possible for you to resize the window to show more files in the list.

If we press any item in this list, Excel will immediately select that cell in the worksheet.

We can also step through each item in the list using the up and down arrow keys.

The “Find All” results list respects the current search options.