Microsoft Excel Keyboard Shortcuts

Microsoft Excel is the most widely used spreadsheet application in the world. Whether you use Excel for personal purpose or in office, here is the complete list of shortcuts that will help to improve the productivity.

Download Excel keyboard shortcuts PDF

Microsoft Excel Keyboard Shortcuts

The keyboard shortcuts are tested and works in most versions of the Microsoft Excel in Windows based computers. The shortcuts are categorized as below and use the search box to filter the results in the below table.

  • Menu – related to menu items and ribbon icons
  • Dialog box – opens up the dialog box
  • Function – insert a function
  • Data processing – used for spreadsheet data processing in workbooks like copy and paste
  • Formatting – text formatting like bold, double underline, strikethrough, etc.
  • Navigation – move within and outside the workbook
  • Workbook – applicable at window level like resizing, minimizing, etc.
  • General – general purpose shortcuts
ShortcutDescriptionCategory
AltActivate access keys (then press further keys to go to the required menu item)Menu
Alt + =Apply automatic summation when used down the cells with numbers. Apply sum function when used on empty cell.Function
Alt + AGo to Data menuMenu
Alt + A, MOpen Remove Duplicate dialog boxDialog box
Alt + EnterCreate a new line within a cellData processing
Alt + FOpen File menuMenu
Alt + F1Insert chart on the active sheetData processing
Alt + F2Save as workbookMenu
Alt + F4Close workbookMenu
Alt + F8Open Macro popup boxDialog box
Alt + F10Show or hide selection paneGeneral
Alt + F11Open Microsoft Visual Basic editor for ExcelData processing
Alt + HHighlight menu and go to Home menuMenu
Alt + H, 0Increase one decimal place of the numberMenu
Alt + H, 3, DDouble underline the selected contentMenu
Alt + H, 5Reduce indentMenu
Alt + H, 6Increase indentMenu
Alt + H, 9Reduce one decimal place of the numberMenu
Alt + H, A, BAlign content in bottom of the cellMenu
Alt + H, A, CAlign centerMenu
Alt + H, A, LLeft alignmentMenu
Alt + H, A, MAlign content in middle of the cellMenu
Alt + H, A, NApply accounting format from the listMenu
Alt + H, A, RRight alignmentMenu
Alt + H, A, TAlign content in top of the cellMenu
Alt + H, BOpen border dropdownMenu
Alt + H, CAlign centerFormatting
Alt + H, C, POpen Copy Picture dialog boxDialog box
Alt + H, D, CDelete the column of the active cellData processing
Alt + H, E, AClear the selected cell dataData processing
Alt + H, E, RRemove hyperlinks from the selected cellsData processing
Alt + H, F, I, JJustify the selected cell contentFormatting
Alt + H, F, I, LCopy the content on the right cell to the current active cellData processing
Alt + H, F, I, RCopy the content on the left cell to the current active cellData processing
Alt + H, F, I, UCopy the content on the below cell to the current active cellData processing
Alt + H, F, OOpen clipboard paneData processing
Alt + H, HChoose the color to fillMenu
Alt + H, O, IAutofit the width of the selected columnGeneral
Alt + H, U, AAverage number functionFunction
Alt + H, U, CCount numbersFunction
Alt + H, U, IMinimum number functionFunction
Alt + H, U, MMaximum number functionFunction
Alt + H, V, EPaste content with source values and formatting (you should have copied the content before)Data processing
Alt + H, V, IPaste the copied content as a linked picture or imageData processing
Alt + H, V, UPaste the copied content as a picture or imageData processing
Alt + MGo to Formulas menuMenu
Alt + NHighlight menu and go to insert menuMenu
Alt + N, BGo to insert bar chart menuMenu
Alt + N, CGo to insert column chart menuMenu
Alt + N, NGo to insert line chart menuMenu
Alt + N, QGo to insert pie chart menuMenu
Alt + N, ROpen Insert Chart dialog and go to Recommended Chart sectionDialog box
Alt + N, S, DGo to insert custom combo chart menuMenu
Alt + PPage Layout menuMenu
Alt + Page DownMove one screen rightWorkbook
Alt + Page UpMove one screen leftWorkbook
Alt + ROpen Review tabMenu
Alt + R, AShow all commentsMenu
Alt + R, DDelete comment from the cellMenu
Alt + Shift + F1Create new spreadsheetData processing
Alt + Shift + F2Save as workbookWorkbook
Alt + Shift + F4Close workbookWorkbook
Alt + SpacebarOpen control menuMenu
Alt + T, OOpen Excel Options dialogDialog box
Alt + WGo to View menuMenu
Alt + W, F, FFree panes, you should have selected columns or rows beforeMenu
Alt + W, IView the sheet in a page break preview modeMenu
Alt + W, LView the sheet in a normal modeMenu
Alt + W, QOpen zoom dialog boxDialog box
Alt + W, V, GToggle gridlines on or offMenu
Context KeyOpen context menuMenu
Ctrl + 0Hide columnsData processing
Ctrl + 1Open format cells popup boxDialog box
Ctrl + 2Apply boldFormatting
Ctrl + 3Apply italicFormatting
Ctrl + 4Apply underlineFormatting
Ctrl + 5Apply strikethroughFormatting
Ctrl + 6Toggle object displayMenu
Ctrl + 7Show / hide toolbarMenu
Ctrl + 8Show / hide outline symbolsGeneral
Ctrl + 9Hide rowsData processing
Ctrl + -Delete cells or rowsData processing
Ctrl + :Insert current timeData processing
Ctrl + ;Insert system dateData processing
Ctrl + ‘Copy the formula from upper cell to lower cellData processing
Ctrl + “Copy the content from the upper cell to lower cellData processing
Ctrl + ASelect all cells in a sheetWorkbook
Ctrl + Alt + VOpen paste special dialog box when you have copied the content in clipboardDialog box
Ctrl + BBold selected contentFormatting
Ctrl + CCopy selected contentData processing
Ctrl + DCopy the content from the upper cell to lower cellData processing
Ctrl + Down ArrowMove to lower end of the selected rangeNavigation
Ctrl + EUse flash fillData processing
Ctrl + EndGo to the lowest used cell in right corner of a workbookGeneral
Ctrl + EnterFill the range with current entryData processing
Ctrl + FFind content on the sheetData processing
Ctrl + F1Show or hide ribbonMenu
Ctrl + F2Open print preview optionsMenu
Ctrl + F3Open name managerDialog box
Ctrl + F4Close sheetMenu
Ctrl + F5Restore window sizeWorkbook
Ctrl + F6Go to next workbookWorkbook
Ctrl + F7Move the windowWorkbook
Ctrl + F8Resize windowWorkbook
Ctrl + F9Minimize windowWorkbook
Ctrl + F10Maximize windowWorkbook
Ctrl + F11Insert a new macro sheetWorkbook
Ctrl + F12Open fileMenu
Ctrl + GGo to the named cellDialog box
Ctrl + HFind text and replace with another textDialog box
Ctrl + HomeGo to start of the sheetWorkbook
Ctrl + IMake the selected text italicFormatting
Ctrl + KInsert hyperlink on the selected cellData processing
Ctrl + LOpen create table boxDialog box
Ctrl + Left ArrowMove to left end of the selected rangeNavigation
Ctrl + Left ClickSelect only the particular clicked cells in addition to the currently selected cellData processing
Ctrl + NOpen new Excel workbookWorkbook
Ctrl + OGo to open menuMenu
Ctrl + PPrint optionsMenu
Ctrl + Page DownGo to next sheet in a workbookWorkbook
Ctrl + Page UpGo to previous sheet in a workbookWorkbook
Ctrl + QOpen Quick Analysis toolDialog box
Ctrl + RCopy the content from left cell to the right side cellData processing
Ctrl + Right ArrowMove to right end of the selected rangeNavigation
Ctrl + SSave the workbookMenu
Ctrl + Shift + !Format cell in number formatFormatting
Ctrl + Shift + “Copy the content from the upper cell to lower cellData processing
Ctrl + Shift + #Format cell in date formatFormatting
Ctrl + Shift + $Format cell in $ currency formatFormatting
Ctrl + Shift + %Format cell in % formatFormatting
Ctrl + Shift + &Apply border around the cellFormatting
Ctrl + Shift + (Unhide rowsData processing
Ctrl + Shift + )Unhide columnsData processing
Ctrl + Shift + *Select the region nearer to active cellData processing
Ctrl + Shift + +Insert cells or rowsData processing
Ctrl + Shift + :Insert current timeData processing
Ctrl + Shift + @Format cell in time formatFormatting
Ctrl + Shift + ^Format cell in exponential formatFormatting
Ctrl + Shift + _Remove border around the cellFormatting
Ctrl + Shift + ArrowsSelect till the nonblank cell in the arrow directionNavigation
Ctrl + Shift + EndSelect the range from the current cell to the lowest used right corner cell of a workbookNavigation
Ctrl + Shift + FOpen format cell dialog box with font tab openFormatting
Ctrl + Shift + F1Maximize window by hiding menus and ribbonWorkbook
Ctrl + Shift + F3Open create name for selection popup boxDialog box
Ctrl + Shift + F6Go to previous workbook windowWorkbook
Ctrl + Shift + F6Go to previous workbookWorkbook
Ctrl + Shift + F12Open print optionsMenu
Ctrl + Shift + LToggle autofilterGeneral
Ctrl + Shift + OSelect all cells with commentsGeneral
Ctrl + Shift + Page DownSelect current and next sheets (you should have next available sheet for selection)Workbook
Ctrl + Shift + Page UpSelect current and previous sheets (you should have previous available sheet for selection)Workbook
Ctrl + Shift + SpacebarSelect the workbook contentData processing
Ctrl + Shift + TabGo to previous workbookWorkbook
Ctrl + Shift + UExpand / collapse formula barMenu
Ctrl + Shift + ~Format cell as generalFormatting
Ctrl + TOpen create table boxDialog box
Ctrl + TabGo to next workbookWorkbook
Ctrl + UUnderline the textFormatting
Ctrl + Up ArrowMove to upper end of the selected rangeNavigation
Ctrl + VPaste contentData processing
Ctrl + WClose active sheetGeneral
Ctrl + XCut the selected contentData processing
Ctrl + YRedo previous actionData processing
Ctrl + ZUndo previous actionData processing
Down ArrowMove one cell downNavigation
EscCancel the selected or current operationData processing
F1Open Excel helpGeneral
F2Edit active cellData processing
F3Show paste name popup when the names are defined in the workbookDialog box
F4Repeat the last action (like pasting)Data processing
F5Open Go To popup boxDialog box
F6Toggle between menu, ribbon and task pane.Menu
F7Do spell checkData processing
F9Calculate in all sheets in all opened workbooksWorkbook
F10Activate access keysMenu
F11Insert new chart sheetWorkbook
F12Save as the workbookWorkbook
HomeGo to first cell in a rowNavigation
Left ArrowMove one cell leftNavigation
Page DownMove one screen downNavigation
Page UpMove one screen upNavigation
Right ArrowMove one cell rightNavigation
Scroll Lock + HomeGo to upper left corner cell (first cell)Navigation
Shift + 10View context menu (generally opened with right click)Menu
Shift + F2Insert comment on the cellData processing
Shift + F3Insert functionData processing
Shift + F4Find next when finding the textDialog box
Shift + F5Find and replaceDialog box
Shift + F6Activate menuMenu
Shift + F7Open thesaurus to find synonymsGeneral
Shift + F8Add to selectionGeneral
Shift + F10 + MAdd or delete comment from the selected cellData processing
Shift + F11Create new sheetWorkbook
Shift + F12Save as the workbookMenu
Shift + Left ClickSelect all cells till the clicked range in addition to the currently selected cellData processing
Shift + SpacebarSelect the rowGeneral
Shift + TabMove to previous cell or ribbon item or cellNavigation
TabMove to next cell or ribbon item or cellNavigation
Up ArrowMove one cell upNavigation
Windows KeyOpen context menuMenu
Related:  How to Change Embedded File Name in Word, Excel and Office Documents?

Download Alt Code Shortcuts PDF

Recommended Articles:

Leave a Comment