Microsoft Office Excel Shortcuts
Categories
|
|
Function Key ShortcutsDisplays the Microsoft Office
Excel Help task pane. . . . . . . . . . . . . . . . . . .[F1] Displays or hides the “Ribbon”. . . . . . . . . .[Ctrl] + [F1] Creates a chart of the data in the current range. . . . . . . . . . . . . . . . . . . . . . . . .[Alt] + [F1] Inserts a new worksheet. . . . . . . . . . . . . . . .[Alt] + [Shift] + [F1] Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off. . . . . . . . . . . .[F2] Adds or edits a cell comment. . . . . . . . . . .[Shift] + [F2] Displays the Print Preview window. . . . . .[Ctrl] + [F2] Displays the Paste Name dialogue box. . .[F3] Displays the Insert Function dialogue box. [Shift] + [F3] Repeats the last command or action, if possible. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[F4] Closes the selected workbook window. . .[Ctrl] + [F4] Displays the Go To dialogue box. . . . . . . . .[F5] Restores the window size of the selected workbook window. . . . . . . . . . . . . . . . . . . . .[Ctrl] + [F5] Switches between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the Ribbon area. . . . . . . . . . . . . . . . . . . . . . .[F6] Switches between the worksheet, Zoom controls, task pane, and Ribbon. . . . . . . . .[Shift] + [F6] Switches to the next workbook window when more than one workbook window is open. . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [F6] Displays the Spelling dialogue box to check spelling in the active worksheet or selected range. . . . . . . . . . . . . . . . . . . . . . .[F7] Performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel. . . . . . . . . . . . . . . .[Ctrl] + [F7] Performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel. . . . . . . . . . . . . . . .[F8] Enables you to add a non-adjacent cell or range to a selection of cells by using the arrow keys. . . . . . . . . . . . . . . . . . . . . . . . .[Shift] + [F8] Calculates all worksheets in all open workbooks. . . . . . . . . . . . . . . . . . . . . . . . . . . .[F9] Calculates the active worksheet. . . . . . . . .[Shift] + [F9] Minimizes a workbook window to an icon. [Ctrl] + [F9] Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. .[Ctrl] + [Alt] + [F9] Rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. . . . . . . . . . . . .[Ctrl] + [Shift] + [Alt] + [F9] Turns key tips on or off. . . . . . . . . . . . . . . . .F10 Displays the shortcut menu for a selected item. . . . . . . . . . . . . . . . . . . . . . . . . .[Shift] + [F10] Maximizes or restores the selected workbook window. . . . . . . . . . . . . . . . . . . . .[Ctrl] + [F10] Displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message. . . .[Alt] + [Shift] + [F10] Creates a chart of the data in the current range. . . . . . . . . . . . . . . . . . . . . . . . .[F11] Inserts a new worksheet. . . . . . . . . . . . . . . .[Shift] + [F11] Opens the Microsoft Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA). .[Alt] + [F11] Displays the Save As dialogue box. . . . . . .[F12] |
Miscellaneous ShortcutsSelects the tab to the left when the
Ribbon is selected. When a submenu is open, closes the submenu. Otherwise, if a menu is open, selects the next menu. .[Left Arrow] Selects the tab to the right when the Ribbon is selected. When a menu item with a submenu is selected, opens the submenu. Otherwise, if a menu is open, selects the previous menu. . . . . . . .[Right Arrow] Selects the next command when a menu or submenu is open. When a Ribbon tab is selected, navigates down the tab group.In a dialogue box, moves down the options in an open drop-down list, or down the options in a group of options. . . . . . . . . . . . . . . . . . . . .[Down Arrow] Selects the previous command when a menu or submenu is open. When a Ribbon tab is selected, navigates up the tab group.In a dialogue box, moves up the options in an open drop-down list, or up the options in a group of options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Up Arrow] Opens a selected drop-down list. . . . . . . . .[Down Arrow] Opens a selected drop-down list. . . . . . . . .[Alt] + [Down Arrow] Deletes one character to the left in the Formula Bar.Also clears the content of the active cell.In cell editing mode, it deletes the character to the left of the insertion point. . . . . . . . . . . . . . . . . . . . . . . .[Backspace] Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments. In cell editing mode, it deletes the character to the right of the insertion point. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Delete] Moves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on.Also selects the last command on the menu when a menu or submenu is visible. . . . . . . . . . . .[End] Completes a cell entry and selects the cell above. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Shift] + [Enter] Starts a new line in the same cell. . . . . . . .[Alt] + [Enter] Fills the selected cell range with the current entry. . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Enter] Cancels an entry in the cell or Formula Bar.Closes an open menu or submenu, dialogue box, or message window. Closes full screen mode when this mode has been applied, and returns to normal screen mode to display the Ribbon and status bar again. . . . . . . . . . . .[Esc] Minimizes a workbook window to an icon. [Ctrl] + [F9] Moves one screen down in a worksheet. .[Page Down] Moves one screen to the right in a worksheet. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Alt] + [Page Down] Moves to the next sheet in a workbook. . .[Ctrl] + [Page Down] Selects the current and next sheet in a workbook. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [Page Down] Moves one screen up in a worksheet. . . . .[Page Up] Moves one screen to the left in a worksheet.[Alt] + [Page Up] Moves to the previous sheet in a workbook.[Ctrl] + [Page Up] Selects the current and previous sheet in a workbook. . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [Page Up] In a dialogue box, performs the action for the selected button, or selects or clears a check box. . . . . . . . . . . . . . . . . . . . .[Space] Selects an entire column in a worksheet. [Ctrl] + [Space] Selects an entire row in a worksheet. . . . .[Shift] + [Space] Selects the entire worksheet.If the worksheet contains data, selects the current region. Pressing [Ctrl] + [Shift] + SPACE a second time selects the current region and its summary rows. Pressing [Ctrl] + [Shift] + SPACE a third time selects the entire worksheet. When an object is selected, selects all objects on a worksheet. . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [Space] Displays the Control menu for the Microsoft Office Excel window. . . . . . . . . .[Alt] + [Space] Switches to next tab in a dialogue box. . .[Ctrl] + [Tab] Switches to previous tab in a dialogue box.[Ctrl] + [Shift] + [Tab] |