List of All Microsoft Office Excel Keyboard Shortcuts

Microsoft Office Excel is world wide used office tool which allows users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and columns. If you want to be a professional in MS Excel, then you must learn all MS Excel shortcut key combination to make yourself faster and better with Microsoft Excel. Here we present A to Z list of all keyboard shortcut key combinations for MS Excel. You can also download list of all Microsoft Office Excel keyboard shortcuts in pdf file at the end of the post.

Microsoft Excel Shortcut Key Combinations

All MS Excel Shortcut Key Combinations
Ctrl + ASelect All
Ctrl + BBold the selected text/cell
Ctrl + CCopy the selected text/cell
Ctrl + DUses the fill down command to copy the contents and format of topmost cell of a selected range into the cells below.
Ctrl + FFind
Ctrl + GDisplays GOTO dialog box
Ctrl + HReplace
Ctrl + IItalicize the text
Ctrl + JJustify the text
Ctrl + KOpens “Insert Hyperlink” window for new hyperlink or Opens “Edit Hyperlink” window for selected existing hyperlink.
Ctrl + NCreates a new blank workbox
Ctrl + OOpen an existing MS Excel Document
Ctrl + PShows the Print window
Ctrl + RUses the fill right command to copy the contents and formatting of the leftmost cell of the selected range into the cells to right
Ctrl + SSaves active MS Excel document with its current filename and format.
Ctrl + TDisplays the Create Table dialog box.
Ctrl + UUnderline selected text
Ctrl + VPaste copied text/cells
Ctrl + WCloses the selected workbook window.
Ctrl + XCut selected text/cells
Ctrl + YRepeat the last action or command if possible.
Ctrl + ZUndo a previous action
Ctrl + 0Hides the selected columns
Ctrl + 6Alternates between hiding objects, displaying objects and displaying placeholders.
Ctrl + 8Displays or hides the outline symbols
Ctrl + 9Hides the selected rows.
“List of All MS Excel Shortcut Key Combinations”
Ctrl + PageUpSwitches between worksheet tabs from left to right.
Ctrl + PageDownSwitches between worksheet tabs from right to left.
Ctrl + Shift + (Unhides any hidden rows within selection.
Ctrl + Shift + )Unhides any hidden columns within selection.
Ctrl + F5XL, restores the window size
Ctrl + F6Next workbook window.
Ctrl + Shift + F6Previous workbook window.
Ctrl + F9To minimize the workbook.
Ctrl + F11To Open VBE
Ctrl + Shift + F1To open new worksheet
Ctrl + Shift + TABTo activate previous workbook.
Ctrl + Shift + &Applies the outline border to the selected cells.
Ctrl + Shift + ~Applies the general number format.
Ctrl + Shift + $Applies the currency format with two decimal places (Negative numbers in parentheses)
Ctrl + Shift + %Applies the percentage format with no decimal places.
Ctrl + Shift + *Selects the current region around the active cell (the data area enclosed by blank rows and blank columns) in a PivotTable, it selects the Entire Pivot table report.
Ctrl + Shift + :Enters the current time.
Ctrl + Shift + “Copies the values from the cell above the active cell into the cell or formula bar.
All MS Excel Shortcut Key Combinations PDF download at the end of the post
F4During formula typing, adjusts the reference type, absolute to relative, otherwise repeat last action.
Ctrl + ;/:Insert current date.
Ctrl + “/’Copies value from cell above to current cell.
Shift + F2Edits a cell comment.
Alt + F8Opens macro dialog box.
Alt + +/=Auto sums selected cells and place values in cells beneath.
Ctrl + Shift + $/4Currency formats current cell.
Ctrl + Shift + &/7Applies outline borders to selected cells.
Ctrl + Shift + !/1Comma formats current cell.
Ctrl + Shift + FActivates fonts drop list.
Ctrl + Shift + PActivates fonts point size window.
Alt + F1Creates a chart of data in current range.
Alt + Shift + F1Inserts a new worksheet.
Ctrl + F2Displays print preview window.
F3Displays paste name dialog box.
Shift + F3Displays the Insert Function dialog box.
Ctrl + F4Closes the selected workbook window.
Shift + F6Switches between worksheet, Zoom controls, task panel and Ribbon.
Ctrl + SpacebarSelects an entire column.
Shift + SpacebarSelects the entire row.
Ctrl + Shift + SpacebarSelects entire worksheet,

  • If worksheet contains data, Ctrl + Shift + Spacebar selects current region.
  • Pressing Ctrl + Shift + Spacebar second time selects the current region and its summery rows.
  • Pressing Ctrl + Shift + Spacebar third time selects entire worksheet.
Alt + SpacebarDisplays the Control menu for the Microsoft Office Excel window.
Shift + TabMoves to previous cell in worksheet or move to previous option in dialog box.
Ctrl + TabSwitches to next Tab in dialog box.
Ctrl + Shift + TabSwitches to previous tab in dialog box.
Ctrl + END
  • Moves to the last cell in the worksheet, in the lowest used row of the rightmost column.
  •  If the curser is in the formula bar, moves the curser to the end of the text.
Ctrl + Shift + END
  • Extends the selection of the cells to the last cell used on the worksheet (lower right corner).
  • If the curser is in the formula bar, selects all the text in the formula bar from the curser position to the end (this does not affect the height of the formula).
A to Z list of all keyboard shortcut key combinations for MS Excel
Alt + EnterStarts a new line in the same cell.
Ctrl + EnterFills the selected cell range with current entry.
Shift + EnterCompletes a cell entry and selects the cell above.
Esc
  • Cancels an entry in the cell of the formula bar.
  • Closes an open menu or sub-menu, dialog box or message menu.
  • Closes full screen mode and returns to normal mode to display Ribbon and Status bar again.
Arrow KeysMove one cell Up, Down, Left or Right in worksheet.
Shift + Arrow KeysExtends the selection of cells by one.
Ctrl + Arrow KeysMoves to the edge of the current data region in a worksheet.
Backspace
  • Deletes one character to the left in formula bar
  • Also clears the content of the active cell
  • In cell editing mode, deletes one character to the left of insertion point.
Delete
  • Deletes cell contents (formula and data) from selected cells without affecting cell format or comments.
  • In cell editing mode, it deletes one character to the right of insertion point.

Free Download A to Z list of all Microsoft Excel Keyboard Shortcuts in PDF file

Free download all MS Excel shortcuts in pdf file from the link given below.

Download

About Aslam Khan

Hi there, I am a blogger, engineer and a computer geek. I love kittens. I spend some of my time blogging besides full time job as Senior Windows Administrator. I like to learn new things.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.