Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)
To open the find and replace option you can use the keyboard shortcut key Ctrl + H. It shows you the dialog box to enter the value to find and the value to replace and as there are multiple buttons for the options you can use Tab to navigate to all those buttons.
Crtl + H
And if you want to open the find dialog box only you can use the shortcut key Control + F. Both tabs (Find & Replace) are adjoint and you can switch to the other using the Control + Function Key + up and down navigation buttons.