Excel has many dialog boxes that you will use frequently.
All of these dialogs support common features that let you drive them from the keyboard.
To switch tabs, you might use Control + tab to move right though the tabs.
And, too reverse direction, just add the shift key.
Controls in dialogs are highlighted subtly when active.
Here you’re free to see a dotted line.
To step through available controls, use the Tab key.
Just add shift to reverse direction.
you might jump directly to any control in a dialog by pressing Alt then the underlined letter.
So,
Alt K toggles strikethrough and
Alt E toggles superscript
And so on.
And, when you have a checkbox selected, you might toggle it on or off using the spacebar.
To confirm a selection, press either enter or the spacebar.
Note that the buttons in a dialog box have a default selection.
Here, OK is selected, which means that pressing Enter will accept prefs and dismiss the dialog.
you’re free to tab to the buttons at the bottom of a dialog box as well.
