Find All in Excel for Mac

On our continuing journey to bring more capability to Excel for Mac, we’re excited to announce some improvements to the Find and Replace feature—you can now edit cells without having to close the Find dialog first. We’ve also added some long-requested search functionality: Find All!

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.
  3. Click any item in the list to select the corresponding cell in your worksheet.

Animated gif showing the Find All feature.

Leave a Reply

Your email address will not be published.