Excel 快捷键大全

发布时间:2021-06-08

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.

Excel 快捷键大全.doc 将本文的Word文档下载到电脑

精彩图片

热门精选

大家正在看

× 游客快捷下载通道(下载后可以自由复制和排版)

限时特价:7 元/份 原价:20元

支付方式:

开通VIP包月会员 特价:29元/月

注:下载文档有可能“只有目录或者内容不全”等情况,请下载之前注意辨别,如果您已付费且无法下载或内容有问题,请联系我们协助你处理。
微信:fanwen365 QQ:370150219