Following is our standard listing of keyboard shortcut key combinations that excludes any discontinued shortcust and some of the more obscure shortcut alternatives.  That still leave more than 150 entries!

These are the genuine Windows and Excel keyboard shortcuts that support application control and quick activation of commands.  This list does not include accelerator pathways for activating the Ribbon commands which are often incorrectly listed in shortcut listings, as these can be easily derived by looking at the Ribbon, and are subject to change depending upon window size.  See this article for information on working with the Ribbon Accelerators.


See the footnotes for a description of what the settings in each column mean.

Keyboard Shortcut List 

If a set of keys is shown with the plus sign (+) between them, the first (and sometimes second) need to be pressed while the second or last is struck.  If there is no plus sign between keystrokes, they should be pressed in sequence without the keys being held down together.

ShortcutModeActionShortcut SetKey SetBase KeyTypeVersions
AltReadyActivate the RibbonApp & Doc ControlCommand KeysAltMain2007 +
F10ReadyActivate the RibbonApp & Doc ControlFunction KeysF10Main2007 +
ContextMenuReadyDisplay the context menu for selectionApp & Doc ControlCommand KeysContextMenuMainAll
Shift+F10ReadyDisplay the context menu for selectionApp & Doc ControlCommand KeysContextMenuMainAll
F1AllDisplay HelpApp & Doc ControlFunction KeysF1MainAll
Ctrl+F4ReadyClose active workbook windowApp & Doc ControlFunction KeysF4MainAll
Alt+F4ReadyClose the applicationApp & Doc ControlFunction KeysF4MainAll
F6AllActivate next paneApp & Doc ControlFunction KeysF6MainAll
Shift+F6AllActivate previous paneApp & Doc ControlFunction KeysF6MainAll
Ctrl+F6AllActivate next workbook windowApp & Doc ControlFunction KeysF6MainAll
Shift+Ctrl+F6AllActivate previous workbook windowApp & Doc ControlFunction KeysF6MainAll
Ctrl+F7ReadyMove active workbook windowApp & Doc ControlFunction KeysF7MainAll
Ctrl+F8ReadyResize the active workbook windowApp & Doc ControlFunction KeysF8MainAll
Ctrl+F9ReadyMinimise the active workbook windowApp & Doc ControlFunction KeysF9MainAll
Ctrl+F10ReadyRestore / maximise the active workbook windowApp & Doc ControlFunction KeysF10MainAll
Alt+MinusReadyOpen the workbook control menu (when workbook window not maximised in application)App & Doc ControlSymbol KeysMinus (-)Legacy2010 -
Alt+SpacebarReadyOpen the application control menuApp & Doc ControlAlpha KeysSpacebarMainAll
Ctrl+F1ReadyToggle display of RibbonApp & Doc ControlFunction KeysF1Main2007 +
Alt+1ReadyExecute first command in Quick Access ToolbarQ A TTop Row Numbers1Main2007 +
Alt+2ReadyExecute second command in Quick Access ToolbarQ A TTop Row Numbers2Main2007 +
Alt+3ReadyExecute third command in Quick Access ToolbarQ A TTop Row Numbers3Main2007 +
Alt+4ReadyExecute fourth command in Quick Access ToolbarQ A TTop Row Numbers4Main2007 +
Alt+5ReadyExecute fifth command in Quick Access ToolbarQ A TTop Row Numbers5Main2007 +
Alt+6ReadyExecute sixth command in Quick Access ToolbarQ A TTop Row Numbers6Main2007 +
Alt+7ReadyExecute seventh command in Quick Access ToolbarQ A TTop Row Numbers7Main2007 +
Alt+8ReadyExecute eighth command in Quick Access ToolbarQ A TTop Row Numbers8Main2007 +
Alt+9ReadyExecute ninth command in Quick Access ToolbarQ A TTop Row Numbers9Main2007 +
Ctrl+TabRibbonWhen ribbon activated, moves forwards through controlsApp & Doc
Control
Command KeysTabMain2013 +
Shift+Ctrl+TabRibbonWhen ribbon activated, moves backwards through controlsApp & Doc
Control
Command KeysTabMain2013 +
Ctrl+NReadyCreate new workbook from default templateFile MenuAlpha KeysNMainAll
Ctrl+OReadyDisplay Open dialog box to open a workbookFile MenuAlpha KeysOMainAll
Ctrl+SReadySave active workbookFile MenuAlpha KeysSMainAll
F12ReadyDisplay Save As dialog box to save workbook with new nameFile MenuFunction KeysF12MainAll
Ctrl+PReadyDisplay Print backstage (print dialog in 2007 and prior)File MenuAlpha KeysPMainAll
F11ReadyInsert a new chart sheet before the active sheet, based on default chart, plots data if selection not blankSheet CommandsFunction KeysF11MainAll
Shift+F11ReadyInsert a new worksheet based on the default worksheet template before the active sheetSheet CommandsFunction KeysF11MainAll
Ctrl+F11ReadyInsert a new XLM macro worksheet before the active sheetSheet CommandsFunction KeysF11MainAll
Ctrl+CAllCopy selection to clipboardClipboardAlpha KeysCMainAll
Ctrl+XAllCut selection to clipboardClipboardAlpha KeysXMainAll
Ctrl+VAllPastes from clipboardClipboardAlpha KeysVMainAll
Ctrl+Alt+VAllPastes Special from clipboardClipboardAlpha KeysVMainAll
EnterReadyPastes from clipboard and clears clipboardClipboardCommand KeysEnterMainAll
PrintScreenAllCopy entire desktop to clipboardClipboardCommand KeysPrintScreenMainAll
Alt+PrintScreenAllCopy active dialog box to clipboardClipboardCommand KeysPrintScreenMainAll
Function+SpacebarAllCopy active dialog box to clipboard (Surface)ClipboardAlpha KeysSpacebarAlternateAll
DeleteReadyClears selected cell contents or removes object or chart elementEditingCommand KeysDeleteMainAll
Ctrl+PlusReadyInserts new cells (or copied / cur cells from clipboard)EditingSymbol KeysPlus (+)MainAll
Ctrl+MinusReadyDeletes selected cellsEditingSymbol KeysMinus (-)MainAll
Ctrl+YAllRedo last actionEditingAlpha KeysYMainAll
Ctrl+ZAllUndo last actionEditingAlpha KeysZMainAll
F4ReadyRepeat last actionEditingFunction KeysF4MainAll
Ctrl+DReadyFill down through selectionEditingAlpha KeysDMainAll
Ctrl+RReadyFill right through selectionEditingAlpha KeysRMainAll
Ctrl+KReadyInsert or edit hyperlinkEditingAlpha KeysKMainAll
Ctrl+TReadyCreate table from current selectionEditingAlpha KeysTMainAll
Ctrl+GAllDisplay GoTo dialog box to select rangeSelection/NavigationAlpha KeysGMainAll
Shift+SpacebarAllExtend current selection to whole rowsSelection/NavigationAlpha KeysSpacebarMainAll
Ctrl+SpacebarAllExtend current selection to whole columnsSelection/NavigationAlpha KeysSpacebarMainAll
Ctrl+*ReadySelect the current region of active cellSelection/NavigationSymbol Keys*MainAll
Ctrl+AReadySelect all, but in non-blank cell, first iteration selects current regionSelection/NavigationAlpha KeysAMain2003 +
HomeReady, EnterSelect first unfrozen cell in active rowSelection/NavigationCommand KeysHomeMainAll
HomeEditMove cursor to beginning of current row of formulaSelection/NavigationNavigation KeysHomeMainAll
Shift+HomeReady, EnterExtend selection to first unfrozen cell in active rowSelection/NavigationNavigation KeysHomeMainAll
Shift+HomeEditSelect from cursor to beginning of current row of formulaSelection/NavigationNavigation KeysHomeMainAll
Ctrl+HomeReady, EnterSelect first unfrozen cell in active worksheetSelection/NavigationNavigation KeysHomeMainAll
Ctrl+HomeEditMove cursor to beginning of formulaSelection/NavigationNavigation KeysHomeMainAll
Shift+Ctrl+HomeReady, EnterExtend selection to first unfrozen cell in active worksheetSelection/NavigationNavigation KeysHomeMainAll
Shift+Ctrl+HomeEditSelect from cursor to beginning of formulaSelection/NavigationNavigation KeysHomeMainAll
Ctrl+EndReady, EnterSelect the last cell in active worksheetSelection/NavigationNavigation KeysEndMainAll
Ctrl+EndEditMove cursor to end of formulaSelection/NavigationNavigation KeysEndMainAll
Shift+Ctrl+EndReady, EnterExtend selection to last cell in active worksheetSelection/NavigationNavigation KeysEndMainAll
Shift+Ctrl+EndEditSelect from cursor to end of formulaSelection/NavigationNavigation KeysEndMainAll
EndReady, EnterSets End ModeSelection/NavigationNavigation KeysEndMainAll
EndEditMove cursor to end of current row of formulaSelection/NavigationNavigation KeysEndMainAll
End EnterReadySelect last cell in active rowSelection/NavigationNavigation KeysEndMainAll
Shift+End Shift+EnterReady, EnterExtends selection to last cell in active rowSelection/NavigationNavigation KeysEndMainAll
Ctrl+UpArrowReady, EnterMoves cursor to top of the current region, or selects bottom cell in next region aboveSelection/NavigationNavigation KeysUpArrowMainAll
Ctrl+DownArrowReady, EnterMoves cursor to bottom of the current region, or top of next region belowSelection/NavigationNavigation KeysDownArrowMainAll
Ctrl+RightArrowReady, EnterMoves cursor to right end of the current region, or leftmost cell in next region to rightSelection/NavigationNavigation KeysRightArrowMainAll
Ctrl+LeftArrowReady, EnterMoves cursor to left end of the current region, or rightmost cell in next region to leftSelection/NavigationNavigation KeysLeftArrowMainAll
Shift+Ctrl+UpArrowReady, EnterExtends selection to the top of current region, or to bottom cell of region aboveSelection/NavigationNavigation KeysUpArrowMainAll
Shift+Ctrl+DownArrowReady, EnterExtends selection to bottom of the current region, or top of next region belowSelection/NavigationNavigation KeysDownArrowMainAll
Shift+Ctrl+RightArrowReady, EnterExtends selection to right end of the current region, or leftmost cell in next region to rightSelection/NavigationNavigation KeysRightArrowMainAll
Shift+Ctrl+LeftArrowReady, EnterExtends selection to left end of the current region, or rightmost cell in next region to leftSelection/NavigationNavigation KeysLeftArrowMainAll
Ctrl+PgUpReady, EnterActivate the previous sheet in a workbook (moves forward)
In a tabbed dialog box, activates previous tab
Selection/NavigationNavigation KeysPgUpMainAll
Ctrl+PgDnReady, EnterActivate the next sheet in a workbook (moves backward)
In a tabbed dialog box, activates next tab
Selection/NavigationNavigation KeysPgDnMainAll
Alt+PgUpReady, EnterMoves active cell one screen leftSelection/NavigationNavigation KeysPgUpMainAll
Alt+PgDnReady, EnterMoves active cell one screen rightSelection/NavigationNavigation KeysPgDnMainAll
Shift+Ctrl+PgUpReady, EnterActivate the previous sheet in a workbook, adding it to selected sheetsSelection/NavigationNavigation KeysPgUpMainAll
Shift+Ctrl+PgDnReady, EnterActivate the next sheet in a workbook, adding it to selected sheetsSelection/NavigationNavigation KeysPgDnMainAll
F8AllActivate EXTEND mode. In EXTEND mode, cursor keys extend or shrink the current selection, either from the active cell in range selection, or the active cursor point in formula editing.Selection/NavigationFunction KeysF8MainAll
Shift+F8Ready, EnterActivate ADD SELECTION mode. In ADD SELECTION mode, currently selected ranges remain selected while allowing the user to navigate to the beginning of a new selection.Selection/NavigationFunction KeysF8MainAll
Ctrl+PeriodReady, EnterMove the active cell clockwise around current region. (Note: Period key is also referred-to as the full stop key)Selection/NavigationAlpha KeysPeriodMainAll
Alt+Ctrl+RightArrowReady, EnterMove active cell to top left of next selected area (non-adjacent selection)Selection/NavigationNavigation KeysRightArrowMainAll
Alt+Ctrl+LeftArrowReady, EnterMove active cell to top left of previous selected area (non-adjacent selection)Selection/NavigationNavigation KeysLeftArrowMainAll
Shift+BackspaceReady, EnterReduce selection to active cell onlySelection/NavigationCommand KeysBackspaceMainAll
Ctrl+BackspaceReady, EnterScroll screen so that the active cell is moved on screen when the selection is wider or taller than the viewable areaSelection/NavigationCommand KeysBackspaceMainAll
Alt+;ReadySelect only the visible cells within the current selectionSelection/NavigationSymbol Keys;MainAll
Ctrl+8ReadyToggle display of outline symbols. If bo outline on active worksheet, will trigger Auto OutliningOutliningTop Row Numbers8MainAll
Ctrl+9ReadyHide the rows of the current selectionOutliningTop Row Numbers9MainAll
Ctrl+Shift+(ReadyUnhide the rows of the current selectionOutliningTop Row Numbers(MainAll
Ctrl+0ReadyHide the columns of the current selectionOutliningTop Row Numbers0MainAll
Ctrl+Shift+)ReadyUnhide the columns of the current selection
Note that sometimes does not work, depending upon Excel and operating system version. In that case, use accelerators ALT H O U L
OutliningTop Row Numbers)MainAll
BackspaceReadyDeletes cell contents and sets Enter mode for formula entryFormula EditingCommand KeysBackspaceMainAll
F2AllInitiate formula editing, or switch between Enter and Edit mode once formula editing commencedFormula EditingFunction KeysF2MainAll
Shift+F2ReadyEdit (or Insert and Edit) cell commentFormula EditingFunction KeysF2MainAll
F3Enter, EditDisplays the Paste Name dialog box to paste a name into the current formulaFormula EditingFunction KeysF3MainAll
Shift+F3ReadyDisplays Paste Function dialog box to commence formula entry or editFormula EditingFunction KeysF3MainAll
Shift+F3Enter, EditDisplays Paste Function or Function Arguments dialogs, depending upon selection within formula, to aid in editing or entering a functionFormula EditingFunction KeysF3MainAll
Ctrl+AEnterPressed after open parentheses - displays the Function Arguments dialog box.Formula EditingAlpha KeysAMainAll
EscEnter, EditAbandon formula editing and return to Ready modeFormula EditingCommand KeysEscMainAll
EnterAllSave the formula being edited or entered in the active cell only and move the active cell forward one cell vertically within the selectionFormula EditingCommand KeysEnterMainAll
Shift+EnterAllSave the formula being edited or entered in the active cell only and move the active cell back one cell vertically within the selectionFormula EditingCommand KeysEnterMainAll
Ctrl+EnterEnter, EditSave the formula being edited or entered throughout the selection. The active cell does not moveFormula EditingCommand KeysEnterMainAll
Ctrl+Shift+EnterEnter, EditSave the formula being edited or entered throughout the selection as an array formula. The active cell does not moveFormula EditingCommand KeysEnterMainAll
Alt+EnterEnter, EditAdd new line character at cursor within formula or cell contents. New line cursor wraps text unconditionally to a new line within the cell.Formula EditingCommand KeysEnterMainAll
TabEnter, EditSave the formula being edited or entered in the active cell only and move the active cell forward one cell horizontally within the selectionFormula EditingCommand KeysTabMainAll
Shift+TabEnter, EditSave the formula being edited or entered in the active cell only and move the active cell backward one cell horizontally within the selectionFormula EditingCommand KeysTabMainAll
InsertEnter, EditToggles INSERT or OVERSTRIKE mode during formula editingFormula EditingCommand KeysInsertMainAll
DeleteEnter, EditDeletes the selected characters or the one character to the right of the insertion pointFormula EditingCommand KeysDeleteMainAll
F4Enter, EditCycle address reference through relative/absolute/mixed.Formula EditingFunction KeysF4MainAll
Alt+DownArrowReadyOpens the AutoComplete Picklist in a cell within a list or activates a drop-down list in cells with data validation.Formula EditingNavigation KeysDownArrowMainAll
Alt+=ReadyAutoSum the selected rangeFormula EditingSymbol Keys=MainAll
Ctrl+;AllEnter the current system date as a static valueFormula EditingSymbol Keys; (semi-colon)MainAll
Ctrl+Shift+:AllEnter the current system time as a static valueFormula EditingSymbol Keys: (colon)MainAll
Ctrl+'AllCopy the formula from the cell above without changing any reference addressesFormula EditingSymbol Keys' (apostrophe)MainAll
Ctrl+Shift+"AllCopy the value from the cell aboveFormula EditingSymbol Keys" (quotation)MainAll
Ctrl+Shift+UAllToggle the formula bar open or closedFormula EditingAlpha KeysUMainAll
Ctrl+Shift+~ReadyFormat selection with General number formatFormattingTop Row Numbers~ (tilde)MainAll
Ctrl+Shift+!ReadyFormat selection with Number number format with thousands separator and 2 decimal places
Format string applied: #,##0.00
FormattingTop Row Numbers! (exclamation)MainAll
Ctrl+Shift+@ReadyFormat selection with AM/PM Time number format
Format string applied: h:mm AM/PM
FormattingTop Row Numbers@MainAll
Ctrl+Shift+#ReadyFormat selection with Date number format
Format string applied: d-mmm-yy
FormattingTop Row Numbers#MainAll
Ctrl+Shift+$ReadyFormat selection with Currency number format
Format string applied:
$#,##0.00;[Red]-$#,##0.00
FormattingTop Row Numbers$MainAll
Ctrl+Shift+%ReadyFormat selection with Percent number format with no decimals
Format string applied: 0%
FormattingTop Row Numbers%MainAll
Ctrl+Shift+^ReadyFormat selection with Scientific number format
Format string applied: 0.00E+00
FormattingTop Row Numbers^MainAll
Ctrl+BAllFormat selection as bold, or toggle bold format during data entryFormattingAlpha KeysBMainAll
Ctrl+IAllFormat selection as italics, or toggle italic format during data entryFormattingAlpha KeysIMainAll
Ctrl+UAllFormat selection as underlined, or toggle underline format during data entryFormattingAlpha KeysUMainAll
Ctrl+5AllFormat selection as struck-through, or toggle strike-through format during data entryFormattingTop Row Numbers5MainAll
Ctrl+Shift+&ReadyApply an outline border to selection. Note it uses the last border type selected from the Borders menu on the Home ribbonFormattingTop Row Numbers& (ampersand)MainAll
Ctrl+Shift+_ReadyRemoves all borders from the selectionFormattingTop Row Numbers_ (underscore)MainAll
Ctrl+Shift+FReadyOpens the Format Cells dislog with the Font tab activatedFormattingAlpha KeysFMain2007 +
Alt+'ReadyOpens the Modify Style dialog for the style of the current selectionFormattingAlpha KeysFMain2007 +
F3ReadyDisplays Paste Name dialog box to enable pasting of a name (creates formula in blank cell), also includes Paste List button to paste a list of names starting at the active cellName ManagementFunction KeysF3MainAll
Ctrl+F3ReadyOpens the Name Manager dislog boxName ManagementFunction KeysF3Main2007 +
Shift+Ctrl+F3ReadyOpens the Create Names from Selection dialogName ManagementFunction KeysF3MainAll
Alt+Ctrl+F3ReadyOpends the Define Name dialog BoxName ManagementFunction KeysF3MainAll
Alt+F3ReadyActivates Name Box (in formula bar)Name ManagementFunction KeysF3Main2019+
Ctrl+FReadyOpens the Find and Replace dialog box with Find tab activeAudit / ReviewAlpha KeysFMainAll
Shift+F4ReadyRepeat the last find commandAudit / ReviewFunction KeysF4MainAll
Ctrl+HReadyOpens the Find and Replace dialog box with Replace tab activeAudit / ReviewAlpha KeysHMainAll
F7ReadySpell Check - if more than one cell selected, within the selection, otherwise whole worksheetAudit / ReviewFunction KeysF7MainAll
Ctrl+`ReadyToggle formua / value viewAudit / ReviewTop Row Numbers` (grave)MainAll
Ctrl+6ReadyToggle display of graphical objectsAudit / ReviewTop Row Numbers6MainAll
Shift+Ctrl+SpacebarReadySelect all graphical objkects on sheet if one already selectedAudit / ReviewAlpha KeysSpacebarMainAll
Ctrl+[ReadySelect direct precedent cellsAudit / ReviewSymbol Keys[MainAll
Ctrl+Shift+{ReadySelect all precedent cellsAudit / ReviewSymbol Keys{MainAll
Ctrl+]ReadySelect direct dependent cellsAudit / ReviewSymbol Keys]MainAll
Ctrl+Shift+}ReadySelect all dependent cellsAudit / ReviewSymbol Keys}MainAll
Ctrl+\ReadySelect row differencesAudit / ReviewSymbol Keys\MainAll
Ctrl+|ReadySelect column differencesAudit / ReviewSymbol Keys| (broken bar)MainAll
Ctrl+/ReadySelect the current arrayAudit / ReviewSymbol Keys/MainAll
Ctrl+Shift+OReadySelect cells within current selection that have commentsAudit / ReviewAlpha KeysOMainAll
Ctrl+Shift+LReadyAutoFilter the currently selected rangeAudit / ReviewAlpha KeysLMainAll
F9Enter, EditCalculate the part of the formula selected, displaying the calculated result. If the formula is unselected, calculate the entire formula.
Note, if you press enter, the formula will be replaced by the calculated value - remember to use Esc key to exit after calculation
Audit / ReviewFunction KeysF9MainAll
F9ReadyRecalculate open workbooks - minimal recalculation onlyCalculationFunction KeysF9MainAll
Shift+F9ReadyRecalculate the active worksheet onlyCalculationFunction KeysF9MainAll

About the Columns

Shortcut
The combination of keys that make up the keyboard shortcut.
Mode
Ready: Ready mode is the normal selection command mode, denoted by the Ready flag in the Status Bar.
Enter:  Enter mode is the normal entry mode for formulas and constant values to be stored in cells.  It is denoted by the Enter or Point flags in the Ststus Bar.
Edit:    Edit mode is the mode for changing formula and cell contents.  Toggle between Enter and Edit modes using the F2 key.
All:      The shortcut works in all modes shown here.
Action
Describes the action taken taken by the shortcut key combination.
Shortcut Set
The action set for the different modes of interaction with Excel.  This allows filtering the list of shortcuts to the set of commands for specific types of work.
Key Set
Denotes which part of the key set the command is associated with.
The entry Top Row Numbers refers to the numeric / symbol keys in the top row of the keyboard.  It is importan to note that keyboard shortcuts including numbers, such as Ctrl+1, only work with the top row keys and NOT the numeric keypad.
Base Key
The base key for the shortcut.  To allow searching for all the combinations associated with a specific key, or sorting by key.
Type
Main:        The main keyboard shortcut combination
Alternate:  Some commands have two combinations available that are worthy of note.
Legacy:     Entries for old keyboard shortcuts for compatibility with old versions of Excel and Lotus 1-2-3.
Versions
The versions of Excel for which the command works.