Dialog Boxes – Microsoft Excel Shortcuts
200 Excel Shortcuts for PC and Mac
So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in Excel. Well, get ready to be even fancier (and more productive) because we’ve curated 200 of the best Excel keyboard shortcuts.
Dialog Boxes
An Excel dialog box can help you make decisions about your worksheet. These shortcuts will help you open and work with dialog boxes like a pro.
| Shortcut | Windows | Mac |
|---|---|---|
| Open macro dialog box This short pops open a macro dialog box for you to control. | Alt F8 | Fn Option f8 |
| Move to next dialog control While working in a dialog box, this shortcut is active and useful for navigation between controls. Use this shortcut to move forwards to the next control. | Tab | Tab |
| Move to previous dialog control While working in a dialog box, this shortcut is active and useful for navigation between controls. Use this shortcut to move backwards to the previous control. | Shift Tab | Shift Tab |
| Move to next dialogue tab Switch to the next dialogue box tab instantly with this shortcut. | Ctrl Tab | Control Tab |
| Move to previous dialog tab Switch to the previous dialog box tab instantly with this shortcut. | Ctrl Shift Tab | Control Shift Tab |
| Accept or enter Complete an edit or action within the dialogue box. | Enter | Return |
| Toggle checkbox Dialogue boxes often have options controlled by checkboxes. This shortcut allows for efficient control of these checkboxes, toggling them on and off with the touch of a button. | Space | Space |
| Exit dialog box Escape from your dialog box and return to traditional work within Excel. | Esc | Esc |