Which keyboard shortcut is used to open the “Find and Replace” dialog in Excel?

1. a) Ctrl+F

2. b) Ctrl+R

3. c) Ctrl+H

4. d) Alt+F4

Show Answer

a) Ctrl+F

In Excel, you can open the “Find and Replace” dialog using the keyboard shortcut Ctrl + F. This shortcut allows you to quickly access the “Find and Replace” feature, which is handy for searching for specific data in your Excel worksheet and replacing it with another value or performing other search-related tasks.