Shortcuts to find and replace

Control F also works on a Mac.

After you run a find, and the Find dialog is closed.

This is a handy way to step through matches without the find dialog blocking your view.

To do a find and replace, use Control + H on both Windows and Mac.

Excel will open up the Replace dialog with the replace field visible and in focus.

Here’s a couple more quick tips on Find and Replace.

Before you find, if you make a selection first, you automatically limit the search to that selection.