Quick, clean, and to the point

Display find and replace, replace selected

Windows shortcut 
Mac shortcut 

This shortcut will display the Find dialog with the Replace option selected. On a Mac, the Replace dialog is displayed, but the replace field is not selected as on Windows.

Related videos

The videos below demonstrate this shortcut.
In this video we'll look at how to replace what you've found. Find and replace is a powerful tool when making global changes to worksheets.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.