Overview

Total Shortcuts: 123

• Navigating in cells:21 shortcuts
• Formatting cells:34 shortcuts
• Making selections and performing actions:19 shortcuts
• Working with data, functions, and the formula bar:23 shortcuts
• Power Pivot shortcuts:26 shortcuts

Navigating in cells

• Move to the previous cell in a worksheet or the previous option in a dialogShift + Tab
• Move one cell up in a worksheetUp
• Move one cell down in a worksheetDown
• Move one cell left in a worksheetLeft
• Move one cell right in a worksheetRight
• Move to the edge of the current data region in a worksheetCtrl + Arrow
• Move to the last cell in the row or columnEnd
• Move to the last cell on a worksheet, to the lowest used row of the rightmost used columnCtrl + End
• Extend the selection of cells to the last used cell on the worksheet (lower-right corner)Ctrl + Shift + End
• Move to the cell in the upper-left corner of the window when Scroll Lock is turned onHome + Scroll Lock
• Move to the beginning of a worksheetCtrl + Home
• Move one screen down in a worksheetPgDn
• Move to the next sheet in a workbookCtrl + PgDn
• Move one screen to the right in a workbookAlt + PgDn
• Move one screen up in a worksheetPgUp
• Move one screen to the left in a worksheetAlt + PgUp
• Move to the previous sheet in a workbookCtrl + PgUp
• Move one cell to the right in a worksheetTab
• Open the list of validation choices on a cell that has data validation options applied to itAlt + Down
• Cycle through floating shapes (such as text boxes or images)Ctrl + Alt + 5
• Exit the floating shape navigation and return to the normal navigationEsc

Formatting cells

• Open the Format Cells dialogCtrl + 1
• Format fonts in the Format Cells dialogCtrl + Shift + F
• Edit the active cell and put the insertion point at the end of its contentsF2
• Add or edit a cell commentShift + F2
• Open the insert dialog to insert blank cellsCtrl + Shift + +
• Open the Delete dialog to delete selected cellsCtrl + Shift + -
• Enter the current timeCtrl + Shift + :
• Enter the current dateCtrl + ;
• Switch between displaying cell values or formulas in the worksheetCtrl + `
• Copy a formula from the cell above the active cell into the cell or Formula BarCtrl + '
• Move the selected cellsCtrl + X
• Copy the selected cellsCtrl + C
• Paste content at the insertion point, replacing any selectionCtrl + V
• Open the Paste Special dialogCtrl + Alt + V
• Italicize text (toggle)Ctrl + I
• Bold text (toggle)Ctrl + B
• Underline text (toggle)Ctrl + U
• Apply or remove strikethrough formattingCtrl + 5
• Switch between hiding objects, displaying objects, and displaying placeholders for objectsCtrl + 6
• Apply an outline border to the selected cellsCtrl + Shift + &
• Remove the outline border from the selected cellsCtrl + Shift + _
• Display or hide the outline symbolsCtrl + 8
• Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells belowCtrl + D
• Apply the General number formatCtrl + Shift + ~
• Apply the Currency format with two decimal placesCtrl + Shift + $
• Apply the Percentage format with no decimal placesCtrl + Shift + %
• Apply the Scientific number format with two decimal placesCtrl + Shift + ^
• Apply the Date format with the day, month, and yearCtrl + Shift + #
• Apply the Time format with the hour and minute, and AM or PMCtrl + Shift + @
• Apply the Number format with two decimal places, thousands separator, and minus for negative valuesCtrl + Shift + !
• Open the Insert hyperlink dialogCtrl + K
• Check spelling in the active worksheet or selected rangeF7
• Display the Quick Analysis options for selected cells that contain dataCtrl + Q
• Display the Create Table dialogCtrl + L

Making selections and performing actions

• Select the entire worksheetCtrl + A
• Select the current and next sheet in a workbookCtrl + Shift + PgDn
• Select the current and previous sheet in a workbookCtrl + Shift + PgUp
• Extend the selection of cells by one cellShift + Arrow
• Extend the selection of cells to the last nonblank cell in the same column or row as the active cellCtrl + Shift + Arrow
• Turn extend mode on and use the arrow keys to extend a selection (toggle)F8
• Add a non-adjacent cell or range to a selection of cells by using the arrow keysShift + F8
• Start a new line in the same cellAlt + Enter
• Fill the selected cell range with the current entryCtrl + Enter
• Complete a cell entry and select the cell aboveShift + Enter
• Select an entire column in a worksheetCtrl + Space
• Select an entire row in a worksheetShift + Space
• Select all objects on a worksheet when an object is selectedCtrl + Shift + Space
• Extend the selection of cells to the beginning of the worksheetCtrl + Shift + Home
• Select the current region if the worksheet contains dataCtrl + A
• Select the current region around the active cellCtrl + Shift + *
• Select the first command on the menu when a menu or submenu is visibleHome
• Repeat the last command or action, if possibleCtrl + Y
• Undo the last actionCtrl + Z

Working with data, functions, and the formula bar

• Edit the active cell and put the insertion point at the end of its contentsF2
• Expand or collapse the formula barCtrl + Shift + U
• Cancel an entry in the cell or Formula BarEsc
• Complete an entry in the formula bar and select the cell belowEnter
• Move the cursor to the end of the text when in the formula barCtrl + End
• Select all text in the formula bar from the cursor position to the endCtrl + Shift + End
• Calculate all worksheets in all open workbooksF9
• Calculate the active worksheetShift + F9
• Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculationCtrl + Alt + F9
• Display the menu or message for an Error Checking buttonAlt + Shift + F10
• Display the Function Arguments dialog when the insertion point is to the right of a function name in a formulaCtrl + A
• Insert argument names and parentheses when the insertion point is to the right of a function name in a formulaCtrl + Shift + A
• Invoke Flash Fill to automatically recognize patterns in adjacent columns and fill the current columnCtrl + E
• Cycle through all combinations of absolute and relative references in a formula if a cell reference or range is selectedF4
• Insert a functionShift + F3
• Copy the value from the cell above the active cell into the cell or formula barCtrl + Shift + '
• Create an embedded chart of the data in the current rangeAlt + F1
• Create a chart of the data in the current range in a separate Chart sheetF11
• Define a name to use in referencesAlt + M
• Paste a name from the Paste Name dialogF3
• Move to the first field in the next record of a data formEnter
• Create, run, edit, or delete a macroAlt + F8
• Open the Microsoft Visual Basic for Applications EditorAlt + F11

Power Pivot shortcuts

• Select the entire tableCtrl + A
• Copy selected dataCtrl + C
• Delete the tableCtrl + D
• Move the tableCtrl + M
• Rename the tableCtrl + R
• Save the fileCtrl + S
• Redo the last actionCtrl + Y
• Undo the last actionCtrl + Z
• Select the current columnCtrl + Space
• Select the current rowShift + Space
• Select all cells from the current location to the last cell of the columnShift + PgUp
• Select all cells from the current location to the first cell of the columnShift + PgDn
• Select all cells from the current location to the last cell of the rowShift + End
• Select all cells from the current location to the first cell of the rowShift + Home
• Move to the previous tableCtrl + PgUp
• Move to the next tableCtrl + PgDn
• Move to the first cell in the upper left corner of the selected tableCtrl + Home
• Move to the last cell in the lower right corner of the selected tableCtrl + End
• Move to the first cell of selected rowCtrl + Left
• Move to the last cell of selected rowCtrl + Right
• Move to the first cell of selected columnCtrl + Up
• Move to the last cell of selected columnCtrl + Down
• Close a dialog or cancel a process, such as a paste operationCtrl + Esc
• Open the AutoFilter Menu dialogAlt + Down
• Open the Go To dialogF5
• Recalculate all formulas in the Power Pivot windowF9