Hey, Office Insiders! Steve Kraynak, Program Manager on the Excel team, is 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!
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).