Following is our most comprehensive listing of all the keyboard shortcut key combinations for all versions of Excel.  It includes some alternate combinations that provide legacy support from old versions of Excel, or the support for the old XT Keyboards that lacked F11 and F12 keys. It also includes some now discontinued shortcuts for features removed from more recent versions of Excel.  A reduced set of shortcuts which does not include unnecessary duplicates or discontinued keys can be found here.

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 and Doc ControlCommand KeysAltMain2007 +
F10ReadyActivate the RibbonApp and Doc ControlFunction KeysF10Main2007 +
/ReadyActivate the RibbonApp and Doc ControlSymbol Keys/Legacy2007 +
ContextMenuReadyDisplay the context menu for selectionApp and Doc ControlCommand KeysContextMenuMainAll
Shift+F10ReadyDisplay the context menu for selectionApp and Doc ControlCommand KeysContextMenuMainAll
F1AllDisplay HelpApp and Doc ControlFunction KeysF1MainAll
Ctrl+F4ReadyClose active workbook windowApp and Doc ControlFunction KeysF4MainAll
Ctrl+WReadyClose active workbook windowApp and Doc ControlAlpha KeysWAlternateAll
Alt+F4ReadyClose the applicationApp and Doc ControlFunction KeysF4MainAll
F6AllActivate next paneApp and Doc ControlFunction KeysF6MainAll
Shift+F6AllActivate previous paneApp and Doc ControlFunction KeysF6MainAll
Ctrl+F6AllActivate next workbook windowApp and Doc ControlFunction KeysF6MainAll
Ctrl+TabAllActivate next workbook windowApp and Doc ControlCommand KeysTabAlternateAll
Shift+Ctrl+F6AllActivate previous workbook windowApp and Doc ControlFunction KeysF6MainAll
Shift+Ctrl+TabAllActivate previous workbook windowApp and Doc ControlCommand KeysTabAlternateAll
Ctrl+F7ReadyMove active workbook windowApp and Doc ControlFunction KeysF7MainAll
Ctrl+F8ReadyResize the active workbook windowApp and Doc ControlFunction KeysF8MainAll
Ctrl+F9ReadyMinimise the active workbook windowApp and Doc ControlFunction KeysF9MainAll
Ctrl+F10ReadyRestore / maximise the active workbook windowApp and Doc ControlFunction KeysF10MainAll
Alt+MinusReadyOpen the workbook control menu (when workbook window not maximised in application)App and Doc ControlSymbol KeysMinus (-)Legacy2010 -
Alt+SpacebarReadyOpen the application control menuApp and Doc ControlAlpha KeysSpacebarMainAll
Ctrl+F1ReadyToggle display of RibbonApp and Doc ControlFunction KeysF1Main2007 +
Ctrl+7ReadyToggle display of Standard toolbarApp and Doc ControlTop Row Numbers7Legacy2003 -
Alt+1ReadyExecute first command in Quick Access ToolbarApp and Doc ControlTop Row Numbers1Main2007 +
Alt+2ReadyExecute second command in Quick Access ToolbarApp and Doc ControlTop Row Numbers2Main2007 +
Alt+3ReadyExecute third command in Quick Access ToolbarApp and Doc ControlTop Row Numbers3Main2007 +
Alt+4ReadyExecute fourth command in Quick Access ToolbarApp and Doc ControlTop Row Numbers4Main2007 +
Alt+5ReadyExecute fifth command in Quick Access ToolbarApp and Doc ControlTop Row Numbers5Main2007 +
Alt+6ReadyExecute sixth command in Quick Access ToolbarApp and Doc ControlTop Row Numbers6Main2007 +
Alt+7ReadyExecute seventh command in Quick Access ToolbarApp and Doc ControlTop Row Numbers7Main2007 +
Alt+8ReadyExecute eighth command in Quick Access ToolbarApp and Doc ControlTop Row Numbers8Main2007 +
Alt+9ReadyExecute ninth command in Quick Access ToolbarApp and Doc ControlTop Row Numbers9Main2007 +
Ctrl+TabRibbonWhen ribbon activated, moves forwards through controlsApp and Doc ControlCommand KeysTabMain2013 +
Shift+Ctrl+TabRibbonWhen ribbon activated, moves backwards through controlsApp and Doc ControlCommand KeysTabMain2013 +
Ctrl+TabRibbonWhen ribbon activated, moves focus between Ribbon and Status BarApp and Doc ControlCommand KeysTabLegacy2007 - 2010
Shift+Ctrl+TabRibbonWhen ribbon activated, moves focus between Ribbon and Status BarApp and Doc ControlCommand KeysTabLegacy2007 - 2010
Ctrl+TabRibbonMoves focus forward through toolbarsApp and Doc ControlCommand KeysTabLegacy2003 -
Shift+Ctrl+TabRibbonMoves focus backward through toolbarsApp and Doc ControlCommand KeysTabLegacy2003 -
Ctrl+NReadyCreate new workbook from default templateFile Menu CommandsAlpha KeysNMainAll
Ctrl+OReadyDisplay Open dialog box to open a workbookFile Menu CommandsAlpha KeysOMainAll
Ctrl+F12ReadyDisplay Open dialog box to open a workbookFile Menu CommandsFunction KeysF12LegacyAll
Alt+Ctrl+F2ReadyDisplay Open dialog box to open a workbookFile Menu CommandsFunction KeysF2LegacyAll
Ctrl+SReadySave active workbookFile Menu CommandsAlpha KeysSMainAll
Shift+F12ReadySave active workbookFile Menu CommandsFunction KeysF12LegacyAll
Alt+Shift+F2ReadySave active workbookFile Menu CommandsFunction KeysF2LegacyAll
F12ReadyDisplay Save As dialog box to save workbook with new nameFile Menu CommandsFunction KeysF12MainAll
Alt+F2ReadyDisplay Save As dialog box to save workbook with new nameFile Menu CommandsFunction KeysF2LegacyAll
Ctrl+PReadyDisplay Print backstage (print dialog in 2007 and prior)File Menu CommandsAlpha KeysPMainAll
Shift+Ctrl+F12ReadyDisplay Print backstage (print dialog in 2007 and prior)File Menu CommandsFunction KeysF12LegacyAll
Alt+Shift+Ctrl+F2ReadyDisplay Print backstage (print dialog in 2007 and prior)File Menu CommandsFunction KeysF2LegacyAll
F11ReadyInsert a new chart sheet before the active sheet, based on default chart, plots data if selection not blankSheet CommandsFunction KeysF11MainAll
Alt+F1ReadyInsert a new chart sheet before the active sheet, based on default chart, plots data if selection not blankSheet CommandsFunction KeysF1LegacyAll
Shift+F11ReadyInsert a new worksheet based on the default worksheet template before the active sheetSheet CommandsFunction KeysF11MainAll
Alt+Shift+F1ReadyInsert a new worksheet based on the default worksheet template before the active sheetSheet CommandsFunction KeysF1LegacyAll
Ctrl+F11ReadyInsert a new XLM macro worksheet before the active sheetSheet CommandsFunction KeysF11MainAll
Alt+Ctrl+F1ReadyInsert a new XLM macro worksheet before the active sheetSheet CommandsFunction KeysF1LegacyAll
Ctrl+CAllCopy selection to clipboardClipboard CommandsAlpha KeysCMainAll
Ctrl+InsertAllCopy selection to clipboardClipboard CommandsCommand KeysInsertLegacyAll
Ctrl+XAllCut selection to clipboardClipboard CommandsAlpha KeysXMainAll
Shift+DeleteAllCut selection to clipboardClipboard CommandsCommand KeysDeleteLegacyAll
Ctrl+VAllPastes from clipboardClipboard CommandsAlpha KeysVMainAll
Shift+InsertAllPastes from clipboardClipboard CommandsCommand KeysInsertLegacyAll
EnterReadyPastes from clipboard and clears clipboardClipboard CommandsCommand KeysEnterMainAll
Ctrl+Alt+VAllPastes Special from clipboardClipboard CommandsAlpha KeysVMainAll
PrintScreenAllCopy entire desktop to clipboardClipboard CommandsCommand KeysPrintScreenMainAll
Alt+PrintScreenAllCopy active dialog box to clipboardClipboard CommandsCommand KeysPrintScreenMainAll
Function+SpacebarAllCopy active dialog box to clipboard (Surface)Clipboard CommandsAlpha KeysSpacebarAlternateAll
DeleteReadyClears selected cell contents or removes object or chart elementEditing CommandsCommand KeysDeleteMainAll
Ctrl+PlusReadyInserts new cells (or copied / cur cells from clipboard)Editing CommandsSymbol KeysPlus (+)MainAll
Ctrl+MinusReadyDeletes selected cellsEditing CommandsSymbol KeysMinus (-)MainAll
Ctrl+YAllRedo last actionEditing CommandsAlpha KeysYMainAll
Ctrl+ZAllUndo last actionEditing CommandsAlpha KeysZMainAll
Alt+BackspaceAllUndo last actionEditing CommandsCommand KeysBackspaceLegacyAll
F4ReadyRepeat last actionEditing CommandsFunction KeysF4MainAll
Ctrl+DReadyFill down through selectionEditing CommandsAlpha KeysDMainAll
Ctrl+RReadyFill right through selectionEditing CommandsAlpha KeysRMainAll
Ctrl+KReadyInsert or edit hyperlinkEditing CommandsAlpha KeysKMainAll
Ctrl+TReadyCreate table from current selectionEditing CommandsAlpha KeysTMainAll
Ctrl+LReadyCreate table from current selectionEditing CommandsAlpha KeysLLegacyAll
Ctrl+GAllDisplay GoTo dialog box to select rangeSelection / NavigationAlpha KeysGMainAll
F5AllDisplay GoTo dialog box to select rangeSelection / NavigationFunction KeysF5LegacyAll
Alt+F3ReadyActivate Name Box (latest releases only)Selection / NavigationFunction KeysF3Main2019+
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 +
Ctrl+AReadySelect allSelection / NavigationAlpha KeysALegacy2002 -
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
End HomeReadySelect the last cell in active worksheetSelection / NavigationNavigation KeysEndLegacyAll
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
End UpArrowReady, EnterMoves cursor to right end of the current region, or selects first cell in next region to rightSelection / NavigationNavigation KeysUpArrowLegacyAll
Ctrl+DownArrowReady, EnterMoves cursor to bottom of the current region, or top of next region belowSelection / NavigationNavigation KeysDownArrowMainAll
End DownArrowReady, EnterMoves cursor to bottom of the current region, or top of next region belowSelection / NavigationNavigation KeysDownArrowLegacyAll
Ctrl+RightArrowReady, EnterMoves cursor to right end of the current region, or leftmost cell in next region to rightSelection / NavigationNavigation KeysRightArrowMainAll
End RightArrowReady, EnterMoves cursor to right end of the current region, or leftmost cell in next region to rightSelection / NavigationNavigation KeysRightArrowLegacyAll
Ctrl+LeftArrowReady, EnterMoves cursor to left end of the current region, or rightmost cell in next region to leftSelection / NavigationNavigation KeysLeftArrowMainAll
End LeftArrowReady, EnterMoves cursor to left end of the current region, or rightmost cell in next region to leftSelection / NavigationNavigation KeysLeftArrowLegacyAll
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+UpArrowReadyOpens the AutoComplete Picklist in a cell within a list or activates a drop-down list in cells with data validation.Formula EditingNavigation KeysDownArrowAlternateAll
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+2AllFormat selection as bold, or toggle bold format during data entryFormattingTop Row Numbers2LegacyAll
Ctrl+IAllFormat selection as italics, or toggle italic format during data entryFormattingAlpha KeysIMainAll
Ctrl+3AllFormat selection as italics, or toggle italic format during data entryFormattingTop Row Numbers3LegacyAll
Ctrl+UAllFormat selection as underlined, or toggle underline format during data entryFormattingAlpha KeysUMainAll
Ctrl+4AllFormat selection as underlined, or toggle underline format during data entryFormattingTop Row Numbers4LegacyAll
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 +
Ctrl+Shift+FReadyMoves focus to Font control in Formatting toolbarFormattingAlpha KeysFLegacy2003 -
Alt+'ReadyOpens the Modify Style dialog for the style of the current selectionFormattingAlpha KeysFMain2007 +
Alt+'ReadyMoves focus to the style control in the Formatting toolbarFormattingAlpha KeysFLegacy2003 -
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 dialog boxName ManagementFunction KeysF3Main2007 +
Ctrl+F3ReadyOpens the Define Name dialog boxName ManagementFunction KeysF3Legacy2003 -
Shift+Ctrl+F3ReadyOpens the Create Names from Selection dialogName ManagementFunction KeysF3MainAll
Alt+Ctrl+F3ReadyOpends the Define Name dialog BoxName ManagementFunction KeysF3MainAll
Ctrl+FReadyOpens the Find and Replace dialog box with Find tab activeAudit / ReviewAlpha KeysFMainAll
Shift+F5ReadyOpens the Find and Replace dialog box with Find tab activeAudit / ReviewFunction KeysF5LegacyAll
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
Alt+UReadyMove focus to Insert Autoshapes toolbar iconAudit / ReviewAlpha KeysULegacy2003
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.