Excel 快捷键大全
发布时间:2021-06-08
发布时间: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.
上一篇:12-5,6,end 位移电流 电磁场基本方程的积分形式
下一篇:外架施工技术交底