Excel 快捷键大全

excel shortcut..

Window Controls ALT+TAB LEGEND Switch to the next program. ALT+SHIFT+TAB Blue = Useful Shortcut Switch to the previous program. Green = Uses Shift for "Anchor" or Ctrl for CTRL+ESC or "Window" Key "More" Display the Windows Start menu. CTRL+W or CTRL+F4 Close the selected workbook window. CTRL+F5 Restore the window size of the selected workbook window. F6 Switch to the next pane in a worksheet that has been split (Window menu, Split command). SHIFT+F6 Switch to the previous pane in a worksheet that has been split. CTRL+F6 When more than one workbook window is open, switch to the next workbook window. CTRL+SHIFT+F6 Switch to the previous workbook window. Menu Controls F10 or ALT Select the menu bar, or close an open menu and submenu at the same time. TAB or SHIFT+TAB When a toolbar is selected, select the next or previous button or menu on the toolbar. CTRL+TAB or CTRL+SHIFT+TAB When a toolbar is selected, select the next or previous toolbar. ENTER Open the selected menu, or perform the action for the selected button or command. SHIFT+F10 Display the shortcut menu for the selected item. ALT+SPACEBAR Display the Control menu for the Excel window. DOWN ARROW or UP ARROW When a menu or submenu is open, select the next or previous command. LEFT ARROW or RIGHT ARROW Select the menu to the left or right. When a submenu is open, switch between the main menu and the submenu. HOME or END Select the first or last command on the menu or submenu. ESC Close an open menu. When a submenu is open, close only the submenu. CTRL+DOWN ARROW Display the full set of commands on a menu. CTRL+7 Show or hide the Standard toolbar. 1. Press ALT to select the menu bar.

Window Controls

ALT+TABSwitch to the next program.

ALT+SHIFT+TABSwitch to the previous program.CTRL+ESC or "Window" KeyDisplay the Windows Start menu.

CTRL+W or CTRL+F4

Close the selected workbook window.

CTRL+F5

Restore the window size of the selected workbook window.

F6

Switch to the next pane in a worksheet that has been split (Window menu, Split command).

SHIFT+F6

Switch to the previous pane in a worksheet that has been split.

CTRL+F6

When more than one workbook window is open, switch to the next workbook window.

CTRL+SHIFT+F6

Switch to the previous workbook window.

Menu Controls

F10 or ALT

Select the menu bar, or close an open menu and submenu at the same time.

TAB or SHIFT+TAB

When a toolbar is selected, select the next or previous button or menu on the toolbar.

CTRL+TAB or CTRL+SHIFT+TAB

When a toolbar is selected, select the next or previous toolbar.

ENTER

Open the selected menu, or perform the action for the selected button or command.

SHIFT+F10

Display the shortcut menu for the selected item.

ALT+SPACEBAR

Display the Control menu for the Excel window.

DOWN ARROW or UP ARROW

When a menu or submenu is open, select the next or previous command.

LEFT ARROW or RIGHT ARROW

Select the menu to the left or right. When a submenu is open,

switch between the main menu and the submenu.

HOME or END

Select the first or last command on the menu or submenu.

ESC

Close an open menu. When a submenu is open, close only the submenu.

CTRL+DOWN ARROW

Display the full set of commands on a menu.

CTRL+7

Show or hide the Standard toolbar.

1. Press ALT to select the menu bar.