Excel has a large number dialog boxes that you will use frequently.
First, to allow you to access all dialog controls, you should probably enable a preference.
Go to System Preferences > then Keyboard > and to the shortcuts tab.
Then confirm “All controls” is selected in the Full Keyboard Access area.
This will let you tab and shift tab to select all dialog box controls.
To reverse direction and go left, just add the shift key.
To step through all available controls, use the Tab key.
Notice that each control is highlighted when active.
Add shift to reverse direction.
For dropdown controls, like Underline , use the spacebar to open, and arrow keys to navigate options.
To confirm a selection, press either Enter or the spacebar.
After you select a checkbox, you might toggle it on or off with the spacebar.
Note that Mac dialog boxes have a default button selected.
It’s possible to tab to Cancel button, and then use the spacebar to push the button.
But, if you just want to cancel the dialog, it’s easiest to press the Escape key.
One last note if you are using Excel 2011.
