Microsoft Excel Keyboard Shortcuts – Mega Collection

3
6168

Microsoft Excel’s best side is its shortcuts. These are pure productivity enhancement toppings that everyone craves to learn and know as many as they can as they not only speeds up things but also gives you freedom of multiple input devices at one time.

The following collection of shortcuts is still a work in progress. As I have found that many users are still using Excel 2007 and 2010 version so a keyboard shortcuts only Excel 2013 version won’t suffice. However, collecting all the shortcuts across different versions is a big feat but it must be done. In coming days I will update the list with shortcuts in version 2007 and 2013 with details if they are compatible across versions etc.

I used Excel 2010 as a base version to collect all the shortcuts of Excel in one place. And the result is produced as following. You can access the interactive list of keyboard shortcuts by clicking the green button and it will let you sort, filter and many other things to let you find the keyboard shortcut you want. The keys mentioned in orange-like colour are my personal favourite.

<—- Don’t Forget to click ME! This will open an interactive chart that can help you immensely to find shortcuts for particular need 

CategoryHold (Combo)Key PressKey typeDescription/Output
NoneEscMiscellaneousEscapes command / interface
NoneF1Function KeysOpens Excel help
Data EntryNoneF2Function KeysEnter Edit mode
Data ManagementNoneF3Function Keysopens Past name dialogue box if names are already defined
FormulaNoneF4Function KeysIf not in edit mode: repeats last action
If in editing mode: having cursor with cell address in formula, cycles through absolute and relative references
NavigationNoneF5Function KeysOpens Go To dialogue box
NavigationNoneF6Function KeysSwitch between worksheet, ribbon, task pane, zoom controls
Data ManagementNoneF7Function KeysExecutes “check spelling” command and opens spelling check dialogue box
SelectionNoneF8Function KeysToggles Extended selection mode on and off
FormulaNoneF9Function KeysPerforms recalculation in all worksheets
NavigationNoneF10Function KeysToggles ribbon shortcut keys (key tips) on and off. Alternative to Alt key
FeaturesNoneF11Function KeysInserts a chart of the active range
OptionsNoneF12Function KeysOpens “Save As” dialogue box
InputNone~ or `Miscellaneous`
InputNone1Numeric keys1
InputNone2Numeric keys2
InputNone3Numeric keys3
InputNone4Numeric keys4
InputNone5Numeric keys5
InputNone6Numeric keys6
InputNone7Numeric keys7
InputNone8Numeric keys8
InputNone9Numeric keys9
InputNone0Numeric keys0
InputNone – or _Miscellaneous
InputNone + or =Miscellaneous=
Data EntryNoneBackspaceMiscellaneousIf in edit mode: normal backspace function i.e. delete one character at left
If not in edit mode: Deletes cell content and enters edit mode
NavigationNoneTabMiscellaneousIf in edit mode: Exits edit mode and moves right
If not in edit mode: Simply moves right
InputNoneQAlpha keysq
InputNoneWAlpha keysw
InputNoneEAlpha keyse
InputNoneRAlpha keysr
InputNoneTAlpha keyst
InputNoneYAlpha keysy
InputNoneUAlpha keysu
InputNoneIAlpha keysi
InputNoneOAlpha keyso
InputNonePAlpha keysp
InputNone{ OR [Miscellaneous[
InputNone} OR ]Miscellaneous]
InputNone| OR \Miscellaneous\
InputNoneAAlpha keysa
InputNoneSAlpha keyss
InputNoneDAlpha keysd
InputNoneFAlpha keysf
InputNoneGAlpha keysg
InputNoneHAlpha keysh
InputNoneJAlpha keysj
InputNoneKAlpha keysk
InputNoneLAlpha keysl
InputNone; or :Miscellaneous;
InputNone ‘ or “Miscellaneous ‘
InputNoneEnterMiscellaneousIf in edit mode: Completes cell input. Exits edit mode and move one cell (row) down
If not in edit mode then simply move one cell (row) down
InputNoneZAlpha keysz
InputNoneXAlpha keysx
InputNoneCAlpha keysc
InputNoneVAlpha keysv
InputNoneBAlpha keysb
InputNoneNAlpha keysn
InputNoneMAlpha keysm
InputNone, OR <Miscellaneous,
InputNone. OR >Miscellaneous.
InputNone/ OR ?MiscellaneousIf in edit mode: /
If not in edit mode: toggle ribbon shortcuts (key tips) and quick access toolbar shortcuts ON
NonePrint ScreenSpecial KeysPrint Screen
Data EntryNoneInsertSpecial KeysIf in edit mode: toggles overtype mode on and off
InputNoneDeleteSpecial KeysIf in edit mode: works as normal delete
If not in edit mode: Deletes cell content without entering edit mode
NavigationNoneEndSpecial KeysToggles End mode on and off
NavigationNoneHomeSpecial KeysMoves to the first cell of row
If scroll lock is on: moves to the top-left cell of the  visible excel workspace
NavigationNonePage UpSpecial KeysMove worksheet up by one screen
NavigationNonePage DownSpecial KeysMove worksheet down by one screen
NavigationNoneArrow UpDirectional KeysMove one cell (row) up
If scroll lock is on then move whole screen up by one row
NavigationNoneArrow DownDirectional KeysMove one cell (row) down
If scroll lock is on then move whole screen down by one row
NavigationNoneArrow LeftDirectional KeysMove one cell (column) left
NavigationNoneArrow RightDirectional KeysMove one cell (column) right
InputNoneSpacebarMiscellaneousOn cells: Enters edit mode and input Space
In menus, dialogue boxes acts as button press. In check boxes checks or unchecks, in case of radio buttons selects
NavigationNoneAltMiscellaneousToggles ribbon tool tips on and off
OptionsNoneProperties buttonMiscellaneousOpens context (properties) menu
Data EntryShiftF2Function KeysAdds a comment and enter edit mode in comment
If comment already exists then enter edit mode of comment
FormulaShiftF3Function KeysInsert function by opening function dialogue box
Data EntryShiftF4Function KeysRepeats last find action
NavigationShiftF6Function KeysSwitch between worksheet, zoom control, task pane and ribbon (reverse to F6)
SelectionShiftF8Function KeysEnables user to add non-adjacent cells to selection without holding Shift key down
FormulaShiftF9Function KeysPerforms recalculation in active worksheet only
OptionsShiftF10Function KeysOpens context (properties) menu
OptionsShiftF11Function KeysInserts a new worksheet in active workbook
InputShiftF12Function KeysSave file (same as Ctrl+S)
InputShift~ or `Miscellaneous~
InputShift1Numeric keys!
InputShift2Numeric keys@
InputShift3Numeric keys#
InputShift4Numeric keys$
InputShift5Numeric keys%
InputShift6Numeric keys^
InputShift7Numeric keys&
InputShift8Numeric keys*
InputShift9Numeric keys(
InputShift0Numeric keys)
InputShift – or _Miscellaneous_
InputShift + or =Miscellaneous+
SelectionShiftBackspaceMiscellaneousIf multiple cells are selected, reduce selection only to active cell
NavigationShiftTabMiscellaneousMove to one cell (column) left. In tables it is moving back to previous cell. In dialogue boxes switch to previous field or option
InputShiftQAlpha keysQ
InputShiftWAlpha keysW
InputShiftEAlpha keysE
InputShiftRAlpha keysR
InputShiftTAlpha keysT
InputShiftYAlpha keysY
InputShiftUAlpha keysU
InputShiftIAlpha keysI
InputShiftOAlpha keysO
InputShiftPAlpha keysP
InputShift{ OR [Miscellaneous{
InputShift} OR ]Miscellaneous}
InputShift| OR \Miscellaneous|
InputShiftAAlpha keysA
InputShiftSAlpha keysS
InputShiftDAlpha keysD
InputShiftFAlpha keysF
InputShiftGAlpha keysG
InputShiftHAlpha keysH
InputShiftJAlpha keysJ
InputShiftKAlpha keysK
InputShiftLAlpha keysL
InputShift; or :Miscellaneous:
InputShift ‘ or “Miscellaneous
Data EntryShiftEnterMiscellaneousIf in edit mode: Completes cell input. Exits edit mode and move one cell (row) Up
If not in edit mode then simply move one cell (row) up
InputShiftZAlpha keysZ
InputShiftXAlpha keysX
InputShiftCAlpha keysC
InputShiftVAlpha keysV
InputShiftBAlpha keysB
InputShiftNAlpha keysN
InputShiftMAlpha keysM
InputShift, OR <Miscellaneous<
InputShift. OR >Miscellaneous>
InputShift/ OR ?Miscellaneous?
SelectionShiftArrow UpDirectional KeysExtends the selection by one row above, moving away from active cell
Reduces the selection by one row below moving towards active cell
SelectionShiftArrow DownDirectional KeysExtends the selection by one row below, moving away from active cell
Reduces the selection by one row above moving towards active cell
SelectionShiftArrow LeftDirectional KeysExtends the selection by one column left moving away from active cell
Reduces the selection by one column right moving towards active cell
SelectionShiftArrow RightDirectional KeysExtends the selection by one column right moving away from active cell
Extends the selection by one column left moving towards active cell
SelectionShiftSpacebarMiscellaneousSelects entire row of worksheet.
If active cell is inside table: pressing once will select entire row inside table. Pressing twice select entire row of worksheet
OptionsCtrlF1Function KeysMinimizes/maximizes excel ribbon
OptionsCtrlF2Function KeysEnter Print preview in the backstage
Data MaagementCtrlF3Function KeysOpens name manager dialogue box
OptionsCtrlF4Function KeysCloses active workbook/window
OptionsCtrlF5Function KeysRestores workbook/window size
NavigationCtrlF6Function KeysSwitch to previous workbook/window if multiple workbooks/windows are open
OptionsCtrlF7Function KeysIf window is not maximized (restore position) then hitting this combo enables move function and user can move window with directional keys. Press escape to exit move mode
OptionsCtrlF8Function KeysIf window is not maximized (restore position) then hitting this combo enables size function and let user resize window using directional keys
OptionsCtrlF9Function KeysMinimizes workbook/window inside excel
OptionsCtrlF10Function KeysMaximizes or restores selected workbook/window in excel
FeaturesCtrlF11Function KeysInserts a new macro sheet
OptionsCtrlF12Function KeysOpens “Open file” dialogue box
FormulaCtrl` or ~MiscellaneousToggle formula view on and off
FormattingCtrl1Numeric keysOpens format cell dialogue box
FormattingCtrl2Numeric keysApply/Remove Bold formatting
FormattingCtrl3Numeric keysApply/Remove Italic formatting
FormattingCtrl4Numeric keysApply/Remove Underline formatting
FormattingCtrl5Numeric keysApply/Remove Strikethrough formatting
Ctrl6Numeric keysHide/Display object
Ctrl7Numeric keysShow/hide standard tool bar (Mac only)
FormattingCtrl8Numeric keysShow/hide outline symbols
Ctrl9Numeric keysHides selected row
Ctrl0Numeric keysHides selected column
Data EntryCtrl – or _MiscellaneousOpens delete dialogue box
NavigationCtrlBackspaceMiscellaneousScrolls back to active cell
NavigationCtrlTabMiscellaneousSwitch to next workbook/window if multiple workbooks/windows are open
OptionsCtrlWAlpha keysCloses active/selected workbook/window
Data EntryCtrlRAlpha keysExecutes “fill right” command by filling cells with content in left most cell of selected region
FeaturesCtrlTAlpha keysOpens “create table” diaglogue box selectig the active region automatically
Data EntryCtrlYAlpha keysRepeat last action (like F4)
FormattingCtrlUAlpha keysApply/Remove underline formatting (like Ctrl+4)
FormattingCtrlIAlpha keysApply/Remove Italic formatting (like Ctrl+3)
OptionsCtrlOAlpha keysOpens “Open file” dialogue box (like Ctrl+F12)
OptionsCtrlPAlpha keysEnter Print preview in the backstage (like Ctrl+F2)
SelectionCtrl{ or [MiscellaneousSelects cells on which formula in the active cell directly depends. In other words direct precedents
SelectionCtrl} OR ]MiscellaneousSelects cells that directly depends on the active cell i.e. dependants
SelectionCtrl\MiscellaneousWithin the selection, selects the cells in other rows with values that do not match the values in the row where active cell is
SelectionCtrlAAlpha keysSelects entire worksheet
If worksheet contains data then having active cell within the region selects entire region. Having region selected, hitting combo second time will select whole worksheet
If in formula bar and insertion point is at right to the formula name, opens function argument dialogue box
OptionsCtrlSAlpha keysSave file
Data EntryCtrlDAlpha keysExecutes “fill down” command by filling content in the top most cell of selection in the cells below
Data ManagementCtrlFAlpha keysOpens “find and replace” dialogue box with find tab active
Data ManagementCtrlGAlpha keysOpens “Go to” dialogue box (like F5)
NavigationCtrlHAlpha keysOpens “find and replace” dialogue box with Replace tab active
Data EntryCtrlKAlpha keysOpens “Insert Hyperlink” dialogue box if no hyperlink exists.
Opens “Edit Hyperlink” dialogue box if hyperlink already exists
FeaturesCtrlLAlpha keysOpens “create table” diaglogue box selectig the active region automatically (like Ctrl+T)
Data EntryCtrl;MiscellaneousInput current date in active cell
Data EntryCtrl ‘ or “MiscellaneousCopy the same formula as in the cell above active cell and remains in edit mode
Data EntryCtrlZAlpha keysUndo last action. That includes reversing (deleting) the last entry made in cell(s)
Data EntryCtrlXAlpha keysNormal cut operation
Data EntryCtrlCAlpha keysCopies cell or range of cells
Data EntryCtrlVAlpha keysPaste copied cell(s)
It may paste anything that is on clipboard copied from other sources
FormattingCtrlBAlpha keysApply/Remove Bold formatting
OptionsCtrlNAlpha keysOpens (creates) new worksheet
SelectionCtrl.Alpha keysCycles active cell through corners of selected range
SelectionCtrl /MiscellaneousSelects array
Data EntryCtrlInsertSpecial KeysCopies cell or range of cells (like Ctrl+C)
Data EntryCtrlDeleteSpecial KeysDeletes cell entry (like normal delete key)
If in editing mode: deletes to the end of line from insertion point
NavigationCtrlEndSpecial KeysOn the worksheet: moves to the last (bottom-right) cell in the worksheet
In the editing mode: moves the insertion point to the end
NavigationCtrlHomeSpecial KeysMoves to the beginning of worksheet
NavigationCtrlPage UpSpecial KeysSwitch to previous worksheet in the workbook
NavigationCtrlPage DownSpecial KeysSwitch the next worksheet in the workbook
NavigationCtrlArrow UpDirectional KeysMoves to the top edge of the current region
NavigationCtrlArrow DownDirectional KeysMoves to the bottom edge of the current region
NavigationCtrlArrow RightDirectional KeysMoves to the right edge of the current region
NavigationCtrlArrow LeftDirectional KeysMoves to the left edge of the current region
SelectionCtrlSpacebarMiscellaneousSelects an etire column of the worksheet
If worksheet has table and active cell is within table: hitting combo once will select whole column of the table, hitting twice will select entire column of worksheet
FeaturesAltF1Function KeysInserts a chart of the active range embedded in the same worksheet
OptionsAltF2Function KeysOpens “Save As” dialogue box (like F12)
OptionsAltF4Function KeysPerforms normal close application command and closes excel application
FeaturesAltF8Function KeysOpens macro manager dialogue box
FeaturesAltF10Function KeysOpens shape manager in the form of task pane
FeaturesAltF11Function KeysOpens VBA editor
Alt – or _Miscellaneous
FormulaAlt + or =MiscellaneousInsert autosum formula and performs sum of the concerned cells
OptionsAltTabMiscellaneousNext application
SelectionAlt;MiscellaneousFrom the selection selects only visible cells
Alt ‘MiscellaneousOpens style dialogue box
Data EntryAltEnterMiscellaneousIf in aditing mode: hitting this combo will insert line break (soft enter)
NavigationAltPage UpSpecial KeysMoves one screen to the left
NavigationAltPage DownSpecial KeysMoves one screen to the right
Data EntryAltArrow DownDirectional KeysDisplays a drop down list of select items
AltArrow LeftDirectional KeysRotate the shape selected in anti clock wise direction
AltArrow RightDirectional KeysRotate the shape selected in clock wise direction
OptionsAltSpacebarMiscellaneousOpens window/application control box
FeaturesCtrl+ShiftF3Function KeysOpens “Create Names from Values” dialogue box
Data ManagementCtrl+ShiftF4Function KeysFind previous
NavigationCtrl+ShiftF6Function KeysSwitch to next workbook/window if multiple workbooks/windows are open
OptionsCtrl+ShiftF12Function KeysGoes to print preview in the bakstage view
FormattingCtrl+Shift ` or ~MiscellaneousApply general number format
FormattingCtrl+Shift1Numeric keysApply number format with two decimal places, thousandth separator in form of comma and minus (-) sign for negative for numbers
FormattingCtrl+Shift2Numeric keysApply time format with hours and minutes expressed in 12 hours format with AM or PM
FormattingCtrl+Shift3Numeric keysApply date format with day, month and year
FormattingCtrl+Shift4Numeric keysApply currency format with figures expressed correct to two decimal places and negative figures in round brackets
FormattingCtrl+Shift5Numeric keysApply percentage format with figures expressed in whole numbers i.e. without decimals
FormattingCtrl+Shift6Numeric keysApplies scientific number format with figures expressed up two decimal places
FormattingCtrl+Shift7Numeric keysApply outline border to cell or selected cells
SelectionCtrl+Shift8Numeric keysIf active cell is within range: selects whole range or area within range upto blank cell(s) around sub-region
Ctrl+Shift9Numeric keysUnhides hidden rows within selection
Ctrl+Shift0Numeric keysUnhides hidden columns within selection
FormattingCtrl+Shift – or _MiscellaneousRemoves outline border from cell or selected cells
FeaturesCtrl+Shift + or =MiscellaneousOpens insert dialogue box to insert rows or columns
NavigationCtrl+ShiftTabMiscellaneousSwitch to previous workbook/window if multiple workbooks/windows are open
FormulaCtrl+ShiftUAlpha keysToggles expand/collapse formula bar
Data EntryCtrl+ShiftOAlpha keysSelects all cells that have comments attached
FormattingCtrl+ShiftPAlpha keysOpens format cell dialogue box with font tab selected
SelectionCtrl+Shift[ or {MiscellaneousSelects cells on which formula in the active cell directly or indirectly depends. In other words all precedents
SelectionCtrl+Shift] or }MiscellaneousSelects cells that directly or indirectly depends on the active cell i.e. all dependents
FormulaCtrl+ShiftAAlpha keysHaving the formula written and insertion point at the right of function: prints the formula syntax (arguments with brackets) in the cell as mentioned as tool top while writing formula
FormattingCtrl+ShiftFAlpha keysOpens format cell dialogue box with font tab selected
FeaturesCtrl+ShiftLAlpha keysToggle Filter on/off
Data EntryCtrl+Shift; or :MiscellaneousInserts current system time and stays in editing mode
Data EntryCtrl+Shift ‘ or “MiscellaneousCopies value from the cell immediately above and stays in editing mode
SelectionCtrl+ShiftEndSpecial KeysSelects a region from the active cell to the last cell used in the worksheet
SelectionCtrl+ShiftHomeSpecial KeysSelects a region from the active cell to the beginning of worksheet
SelectionCtrl+ShiftPage UpSpecial KeysSelects current and previous worksheet. This can be repeated to select multiple worksheets backwards
SelectionCtrl+ShiftPage DownSpecial KeysSelects current and next worksheet. This can be repeated to select multiple worksheets forwards
SelectionCtrl+ShiftArrow UpDirectional KeysExtends the selection from the active cell to non-blank cell above in the same column as active cell. If immediate cell above is blank then extends the selection to next blank cell above
SelectionCtrl+ShiftArrow DownDirectional KeysExtends the selection from the active cell to non-blank cell below In the same column as active cell. If immediate cell above is blank then extends the selection to next blank cell below
SelectionCtrl+ShiftArrow RightDirectional KeysExtends the selection from the active cell to non-blank cell to the right In the same row as active cell. If immediate cell above is blank then extends the selection to next blank cell to the right
SelectionCtrl+ShiftArrow LeftDirectional KeysExtends the selection from the active cell to non-blank cell to the left In the same row as active cell. If immediate cell above is blank then extends the selection to next blank cell to the left
SelectionCtrl+ShiftSpacebarMiscellaneousSelects entire worksheet
If worksheet  contains data then hittin this combo will select entire current region. Hitting twice will also select summary rows of current region. Hitting thrice will select entire worksheet
Having object selected: selects all objects in the same worksheet
OptionsAlt+ShiftF1Function KeysInserts new worksheet to active workbook before active worksheet
Alt+ShiftF10Function KeysOpens a message for smart tag. If multiple smart tag exists in worksheet then switches to next tag and displays message for that tag
FormulaAlt+CtrlF9Function KeysPerforms recalculation on all worksheets in all the open workbooks currently
Data EntryAlt+CtrlVAlpha keysOpens Paste special dialogue box only if content is available on clipboard copied from excel or other source
FormulaAlt+Ctrl+ShiftF9Function KeysRecheck dependants and performs recalculation in all worksheets in workbooks currently open

So here you have a big excel keyboard shortcuts collection which is still growing and getting better. If you want to chip in and can tell us which one we missed in our list or to make the collection better in any way that would be really great for the whole excel community. Looking forward to your excellent comments!

3 COMMENTS

  1. Dear Sir, I have required order form / invoices & book keeping a record of those. please help me how i got in excel 2007.

LEAVE A REPLY

Please enter your comment!
Please enter your name here