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.
To open theFind and Replacedialog box, press Control+F or clickHome >Find & Select>Find.
Enter your search term and click theFind Allbutton. 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.
Click any item in the list to select the corresponding cell in your worksheet.
Animated gif showing the Find All feature.
The new Find All and improved Find Dialog is available in the April 2022 monthly update. It will be version 16.60 (220410) or greater.
Do you have an idea to make Excel better? We'd love to hear about it. Go to the Excel forum in Microsoft Feedback to submit your idea or vote for other ideas. You can also click the Feedback button in Excel and choose "I have a suggestion".