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.
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables