Find and Replace has become an indispensable tool for me when working with Excel.
There are so many scenarios where using find and replace allows me to quickly manipulate data and get things done a lot faster.
While there is a way to open the final replace dialog box using the option in the ribbon, lately I’ve been using the keyboard shortcut that I think makes you a lot faster when using this functionality.
In this short tutorial, I will show you the keyboard shortcut to open the Find and Replace dialog box (and everything else you need to know)
Shortcut to Open Find and Replace in Excel
Below is the keyboard shortcut to open the Find and Replace dialog box in Excel:
Control + H
How to Use the Keyboard Shortcut to Open Find and Replace Dialog Box
Below are the steps to use the above keyboard shortcut:
- Select The cell or range of cells on which you want to use the Find and Replace functionality
- Hold the Control key and press the H key
The above steps would open the Find and Replace dialog box, where the replace tab would be selected in the dialog box.
You can also open the same dialogue box by using the keyboard shortcut Control + F (hold the Control key and then press the F key)
- With Control + H – the replace tab is selected
- With Control + F – the find tab is selected
Note that once the final replace dialog box is open, you can switch between the two tabs by using Control PageUp/PageDown
Also, when the Find and Replace dialog box is active, you can use the tab key to go to different parts of the dialogue box (such as the Find what and Replace with fields and the buttons)
Other Excel shortcuts you may also like:
- Excel Keyboard Shortcuts
- SAVE AS in Excel
- Switch Between Tabs/Worksheets in Excel
- Open ‘Go To’ Dialog Box (Shortcut)
Other articles you may also like: