Excel will open up the Replace dialog with the replace field visible and in focus. To do a find and replace, use Control + H on both Windows and Mac. To reverse direction, use Control + Shift + F4 on Windows, Command + Shift + G on a Mac. This is a handy way to step through matches without the find dialog blocking your view. You can repeat the last search with the keyboard shortcut Shift F4 on Windows, and Command G on a Mac.
If you hold down the shift key, you can move through matches in the opposite direction.Īfter you run a find, and the Find dialog is closed. Once you've found something, you can press Return or Enter to 'find again'. To find something in Excel, you can use Control + F on Windows and Command + F on a Mac. In this video, we'll look at the shortcuts you can use for find and replace in Excel.