woman sitting at kitchen table using laptop

Find All in Excel for Mac

Feature deep dive
  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn

Hey, Office Insiders! I’m Steve Kraynak, a Program Manager on the Excel team. I’m excited to announce some improvements to the Find and Replace feature in Excel for Mac—you can now edit cells without having to close the dialog box first. We’ve also added some long-requested search functionality: Find All!

Find All in Excel

Over the years, many users have asked us to add the Find All feature they enjoy in Excel for Windows to Excel for Mac. Now, it’s here!

This update helps you find what you’re looking for faster and more easily, because you can see a list of all the cells that contain your search term. No more having to click Find Next to check the cells one at a time. 

Also, since the updated Find and Replace dialog box is non-modal, you can make edits to cells even with the dialog open (something that wasn’t previously possible).

How it works

It’s easy to use Find All in Excel for Mac.

  1. To open the Find and Replace dialog box, press Control+F or click Home > Find & Select > Find.
  2. Enter your search term and click the Find All button. You’ll notice that the dialog box expands to show a list of all the cells that contain the search term, and the total number of cells in which it appears.

    Screenshot showing Find All feature in Excel for Mac.
  3. Click any item in the list to select the corresponding cell in your worksheet.

    GIF showing how to navigate to a particular cell from the Find All dialog box in Excel for Mac.

Scenarios to try

  • Determine how many cells contain a certain word or value. You can use Find All in Excel to search for a term, and then check the status bar to see how many cells contain it.
  • Quickly locate a specific cell containing your search term. Search for a term using Find All and scan the list of results for the one you want. Click an item to select that cell in the worksheet.
  • Edit a cell with the Find dialog open. Open the Find dialog and search on a term. Click the result to be taken to that cell, and edit the cell without closing the dialog (press Enter or click out of the cell to save your edits).

Tips and tricks

You can easily re-use one of your last five search terms; just click the Find what dropdown arrow and choose the term from the list.Screenshot showing how to access past search terms in Find dialog in Excel for Mac.

Availability

Find All in Excel for Mac is available to Insiders running Version 16.56 (Build 21110701) or later.

Don’t have it yet? It’s probably us, not you.

Features are released over some time to ensure things are working smoothly. We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders. Sometimes we remove elements to further improve them based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as an Insider, have had the opportunity to try it.

Feedback

If you have any comments or questions about the new Find and Replace dialog box or the new Find All capability in Excel for Mac, please let us know by clicking Help > Feedback. We’d love to hear from you!

Learn what other information you should include in your feedback to ensure it’s actionable and reaches the right people. We’re excited to hear from you!

Sign up for the Office Insider newsletter and get the latest information about Insider features in your inbox once a month!