Free Excel Tips & Tricks

Subscribe to Get Daily Excel Tips & Tricks to your Inbox for Free!

Tuesday, July 24, 2018

EXCEL DIALOG BOX SHORTCUT KEYS

EXCEL DIALOG BOX SHORTCUT KEYS

ARROW KEYS
Purpose:Use this excel shortcut key to Move between options in the active drop-down list box or between some options in a group of options.

SPACE
Purpose:Use this excel shortcut key to In a dialog box: perform the action for the selected button, or select/clear a check box. Select or clear a check box in the list.

A ... Z
Purpose:Use this excel shortcut key to Move to an option in a drop-down list box starting with the letter

ALT +A ... ALT +Z
Purpose:Use this excel shortcut key to Select an option, or select or clear a check box.

ENTER
Purpose:Use this excel shortcut key to Perform the action assigned to the default command button in the dialog box.

ESC
Purpose:Use this excel shortcut key to Cancel the command and close the dialog box.

No comments:

Post a Comment

EDITING CELLS USING EXCEL SHORTCUT KEYS

F2 Purpose: Use this excel shortcut key to Edit the active cell with cursor at end of the line. ALT +ENTER Purpose: Use this exc...