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.