Shortcut Keys To Use In Excel

So earlier we saw shortcut keys for the whole computer but today we’re going to check out shortcut keys for Microsoft excel. the shortcut keys will make your life easy as you will not be rolling over your mouse again and again. So lets us get started with Shortcut Keys for Microsoft Excel. We will be going through all kays from A-Z, Ctrl, Shift, and all F keys.

Ctrl+ACtrlASelect AllNone
Ctrl+BCtrlBBoldFormatCellsFontFont StyleBold
Ctrl+CCtrlCCopyEditCopy
Ctrl+DCtrlDFill DownEditFillDown
Ctrl+FCtrlFFindEditFind
Ctrl+GCtrlGGotoEditGoto
Ctrl+HCtrlHReplaceEditReplace
Ctrl+ICtrlIItalicFormatCellsFontFont StyleItalic
Ctrl+KCtrlKInsert HyperlinkInsertHyperlink
Ctrl+NCtrlNNew WorkbookFileNew
Ctrl+OCtrlOOpenFileOpen
Ctrl+PCtrlPPrintFilePrint
Ctrl+RCtrlRFill RightEditFill Right
Ctrl+SCtrlSSaveFileSave
Ctrl+UCtrlUUnderlineFormatCellsFontUnderlineSingle
Ctrl+VCtrlVPasteEditPaste
Ctrl WCtrlWCloseFileClose
Ctrl+XCtrlXCutEditCut
Ctrl+YCtrlYRepeatEditRepeat
Ctrl+ZCtrlZUndoEditUndo
F1F1HelpHelpContents and Index
F2F2EditNone
F3F3Paste NameInsertNamePaste
F4F4Repeat last actionEditRepeat. Works while not in Edit mode.
F4F4While typing a formulaswitch between absolute/relative refsNone
F5F5GotoEditGoto
F6F6Next PaneNone
F7F7Spell checkToolsSpelling
F8F8Extend modeNone
F9F9Recalculate all workbooksToolsOptionsCalculationCalc,Now
F10F10Activate MenubarN/A
F11F11New ChartInsertChart
F12F12Save AsFileSave As
ALSO READ – ADVANCED COMMAND PROMPT TRICKS
ShiftShiftHold down shift for additional functions in Excel’s menunone
Shift+F1ShiftF1What’s This?HelpWhat’s This?
Shift+F2ShiftF2Edit cell commentInsertEdit Comments
Shift+F3ShiftF3Paste function into formulaInsertFunction
Shift+F4ShiftF4Find NextEditFindFind Next
Shift+F5ShiftF5FindEditFindFind Next
Shift+F6ShiftF6Previous PaneNone
Shift+F8ShiftF8Add to selectionNone
Shift+F9ShiftF9Calculate active worksheetCalc Sheet
Shift+F10ShiftF10Display shortcut menuNone
Shift+F11ShiftF11New worksheetInsertWorksheet
Shift+F12ShiftF12SaveFileSave
Ctrl+F3CtrlF3Define nameInsertNamesDefine
Ctrl+F4CtrlF4CloseFileClose
Ctrl+F5CtrlF5XLRestore window sizeRestore
Ctrl+F6CtrlF6Next workbook windowWindow…
Shift+Ctrl+F6ShiftCtrlF6Previous workbook windowWindow…
Ctrl+F7CtrlF7Move windowXLMove
Ctrl+F8CtrlF8Resize windowXLSize
Ctrl+F9CtrlF9Minimize workbookXLMinimize
Ctrl+F10CtrlF10Maximize or restore windowXLMaximize
Ctrl+F11CtrlF11Inset 4.0 Macro sheetNone in Excel 97. In versions prior to 97 – InsertMacro4.0 Macro
Ctrl+F12CtrlF12File OpenFileOpen
Alt+F1AltF1Insert ChartInsertChart…
Alt+F2AltF2Save AsFileSave As
Alt+F4AltF4ExitFileExit
Alt+F8AltF8Macro dialog boxToolsMacroMacros in Excel 97 ToolsMacros – in earlier versions
Alt+F11AltF11Visual Basic EditorToolsMacroVisual Basic Editor
Ctrl+Shift+F3CtrlShiftF3Create name by using names of row and column labelsInsertNameCreate
Ctrl+Shift+F6CtrlShiftF6Previous WindowWindow…
Ctrl+Shift+F12CtrlShiftF12PrintFilePrint
Alt+Shift+F1AltShiftF1New worksheetInsertWorksheet
Alt+Shift+F2AltShiftF2SaveFileSave
Alt+=Alt=AutoSumNo direct equivalent
Ctrl+`Ctrl`Toggle Value/Formula displayToolsOptionsViewFormulas
Ctrl+Shift+ACtrlShiftAInsert argument names into formulaNo direct equivalent
Alt+Down arrowAltDisplay AutoComplete listNone
Alt+’Alt’Format Style dialog boxFormatStyle
Ctrl+Shift+~CtrlShift~General formatFormatCellsNumberCategoryGeneral
Ctrl+Shift+!CtrlShift!Comma formatFormatCellsNumberCategoryNumber
Ctrl+Shift+@CtrlShift@Time formatFormatCellsNumberCategoryTime
Ctrl+Shift+#CtrlShift#Date formatFormatCellsNumberCategoryDate
Ctrl+Shift+$CtrlShift$Currency formatFormatCellsNumberCategoryCurrency
Ctrl+Shift+%CtrlShift%Percent formatFormatCellsNumberCategoryPercentage
Ctrl+Shift+^CtrlShift^Exponential formatFormatCellsNumberCategory,
Ctrl+Shift+&CtrlShift&Place outline border around selected cellsFormatCellsBorder
Ctrl+Shift+_CtrlShift_Remove outline borderFormatCellsBorder
Ctrl+Shift+*CtrlShift*Select current regionEditGotoSpecialCurrent Region
Ctrl++Ctrl+InsertInsert(Rows, Columns, or Cells) Depends on selection
Ctrl+-Ctrl-DeleteDelete(Rows, Columns, or Cells) Depends on selection
Ctrl+1Ctrl1Format cells dialog boxFormatCells
Ctrl+2Ctrl2BoldFormatCellsFontFont StyleBold
Ctrl+3Ctrl3ItalicFormatCellsFontFont StyleItalic
Ctrl+4Ctrl4UnderlineFormatCellsFontFont StyleUnderline
Ctrl+5Ctrl5StrikethroughFormatCellsFontEffectsStrikethrough
Ctrl+6Ctrl6Show/Hide objectsToolsOptionsViewObjectsShow All/Hide
Ctrl+7Ctrl7Show/Hide Standard toolbarViewToolbarsStardard
Ctrl+8Ctrl8Toggle Outline symbolsNone
Ctrl+9Ctrl9Hide rowsFormatRowHide
Ctrl+0Ctrl0Hide columnsFormatColumnHide
Ctrl+Shift+(CtrlShift(Unhide rowsFormatRowUnhide
Ctrl+Shift+)CtrlShift)Unhide columnsFormatColumnUnhide
Alt or F10Alt / F10Activate the menuNone
Ctrl+TabCtrlTabIn toolbar: next toolbarNone
Ctrl+TabCtrlTabIn a workbook: activate next workbookNone
Shift+Ctrl+TabShiftCtrlTabIn toolbar: previous toolbarNone
Shift+Ctrl+TabShiftCtrlTabIn a workbook: activate previous workbookNone
TabTabNext toolNone
Shift+TabShiftTabPrevious toolNone
EnterEnterDo the commandNone
Shift+Ctrl+FShiftCtrlFFont Drop Down ListFormatCellsFont
Shift+Ctrl+F+FShiftCtrlFFFont tab of Format Cell Dialog boxFormatCellsFont
Shift+Ctrl+PShiftCtrlPPoint size Drop Down ListFormatCellsFont

So, this is the end of the article. I hope you must have gained some knowledge about Shortcut keys for Microsoft excel. Subscribe to our newsletter to always get updated about our latest tech post and get stick to the trending things. Till the time stay safe and stay indoors.

Leave a Reply

Your email address will not be published. Required fields are marked *