How Do I Navigate Dialog Boxes With Keyboard Shortcuts In Excel?
I will now attempt to show you the basics of navigating dialog boxes in Excel with keyboard shortcuts — without destroying your sanity. I won’t go too deep because, like you, I want to avoid deep, dark jungles with no return…
Ready? Here we go.
Sometimes you’re working with a dialog box, such as the Find & Replace dialog box, where you’re typing into the boxes with both hands on the keyboard. In this situation, it’s cumbersome to pull your hand off the keyboard to engage the mouse, and then bring it back to the keyboard to resume typing. After you fill in the Find box, it would be much faster to switch to the Replace box using a keyboard shortcut, assuming it’s easy (which it is). So let’s review some shortcuts that will help. Below is the dialog box, showing both tabs — the Find tab and the Replace tab.
If you hit Ctr+F to open the Find and Replace dialog box to the Find tab, you first enter what you want to “Find.” Then, you need to go over to the Replace tab (pictured on the right). To get there, you have several keyboard shortcut options:
- Type Ctrl+Tab. This works for any dialog box with tabs. Ctrl+Shift+Tab will take you backwards, but in this case, with only two tabs, forward and backward take you to the same place.
- Type Alt+P (because the P is in “Replace” is underlined.
I personally find Alt+P a little faster.