Exceljet

Quick, clean, and to the point

Display find and replace, replace selected

Windows shortcut 
CtrlH
Mac shortcut 
H

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

Tip: 23 formula tips to save you time today
In this video, we run through more than 20 tips you can use to save time with Excel formulas today. We believe in making videos that are quick and to the point, so this is a rapid-fire list. We trust that you can rewind the video as needed :)
This is the best site I have been to. Direct & to the point. You guys have (almost) everything I need on one site. -Carl
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