excel表格快捷键（Excel form shortcut key）.docVIP

excel表格快捷键（Excel form shortcut key） Menu and toolbar operations Alt+F activates the file menu Alt+E activates the edit menu Alt+V activates the View menu Alt+I activates the Insert menu Alt+O activates the format menu Alt+T activates the tools menu Alt+D activates the data menu Alt+W activates the window menu Alt+H activates the help menu F10 activation menu Shfit+F10 activates the right-click menu [note] when you use the shortcut key to activate the menu, you can use the up and down arrow keys to move in the menu bar. For the submenu, you can move the arrow with the left and right arrow. When you move to the menu command you want, press the Enter button to run the command. Ctrl+Shift+F activate the font drop-down list box on the toolbar Ctrl+Shift+P activates the font size drop-down list box on the toolbar Does the Ctrl+6 (^) switch make the buttons on some toolbars deal with the available state (ie, invariant gray)? Does the Ctrl+7 () switch display the standard toolbar? Alt+- pop-up Excel top left corner shortcut menu Alt+ spacebar pop-up Excel top left corner shortcut menu Selection operation Ctrl+A to select a range of cells, if there is a range of cells or cell in the external area according to this shortcut will select all of the whole cell in a worksheet. Press the key again to select all cells for the worksheet. Ctrl+Shift+ space select cell area, if there is a range of cells or cell in the external area according to this shortcut will select all of the whole cell in a worksheet. Press the key again to select all cells for the worksheet. F8 extends the selected area. If the selection of a cell, according to the direction of arrow will be continuous cell selection or click a cell and press F8 button and then click another cell can choose the area between the two cell. Shift+F8 can choose contiguous regions continuously. Shift+Ctrl+O selects the cells in the worksheet that have comments Shift+ left arrow left to select area Shift+ right arrow to the right, se