Excel 快捷键大全(2)

excel shortcut..

2. Press CTRL+TAB repeatedly to select different toolbars

Dialog Box Controls

TAB

Move to the next option or option group.

SHIFT+TAB

Move to the previous option or option group.

CTRL+TAB or CTRL+PAGE DOWN

Switch to the next tab in a dialog box.

CTRL+SHIFT+TAB or CTRL+PAGE UP

Switch to the previous tab in a dialog box.

Arrow keys

Move between options in an open drop-down list, or between options in a group of options.

SPACEBAR

Perform the action for the selected button, or select or clear the selected check box.

First letter of an option in a drop-down list

Open the list if it is closed and move to that option in the list.

ALT+ the underlined letter in an option

Select an option, or select or clear a check box.

ALT+DOWN ARROW

Open the selected drop-down list.

ENTER

Perform the action for the default command button in the dialog box

(the button with the bold outline, often the OK button).

ESC

Cancel the command and close the dialog box.

Shortcuts in Edit Mode or entering information in a Dialog Box

HOME

Move to the beginning of the entry.

END

Move to the end of the entry.

LEFT ARROW or RIGHT ARROW

Move one character to the left or right.

CTRL+LEFT ARROW

Move one word to the left.

CTRL+RIGHT ARROW

Move one word to the right.

SHIFT+LEFT ARROW

Select or unselect one character to the left.

SHIFT+RIGHT ARROW

Select or unselect one character to the right.

CTRL+SHIFT+LEFT ARROW

Select or unselect one word to the left.

CTRL+SHIFT+RIGHT ARROW

Select or unselect one word to the right.

SHIFT+HOME

Select from the insertion point to the beginning of the entry.

SHIFT+END

Select from the insertion point to the end of the entry.