List of All Microsoft Excel Keyboard Shortcuts

Microsoft Excel is one of the most used office tools. MS Excel uses a spreadsheet system broken up into rows and columns. It also allows users to organize, format, and calculate data with formulas. If you want to have professional expertise in MS Excel, then you should try to learn all Microsoft Excel shortcuts or key combinations.

Here we present an a to z list of all keyboard shortcut key combinations for MS Excel. You can also download the list of all Microsoft Office Excel keyboard shortcuts in a PDF file at the end of the post.

SEE ALSO: List of all Microsoft Office Word Shortcut Key Combinations.

Microsoft Excel Shortcut Key Combinations

Microsoft Office Ms Excel Keyboard Shortcuts Key Combinations
Microsoft Office Excel Keyboard Shortcuts

In this post, we have arranged all the shortcuts by their combination types. So, you would find it easy to remember them.

All MS Excel Shortcut Key Combinations (Ctrl + A-Z, 0-9)

Ctrl + ASelect all the available rows and columns
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 the 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 the “Insert Hyperlink” window for a new hyperlink. If an existing hyperlink is selected, it opens the “Edit Hyperlink” window.
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 the 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.

SEE ALSO: Best of Windows Keyboard and Mouse Shortcuts for you.

List of All Microsoft Excel Keyboard Shortcuts (Ctrl + Special Keys, Ctrl + Shift + Special Keys)

Ctrl + PageUp Switches between worksheet tabs from left to right
Ctrl + PageDown Switches between worksheet tabs from right to left
Ctrl + Shift + (Unhide any hidden rows within the selection
Ctrl + Shift + ) Unhide any hidden columns within the selection
Ctrl + F5XL, and 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 a new worksheet
Ctrl + Shift + TABTo activate the 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 Pivot table. 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.

SEE ALSO: How to Password Protect your MS Office Documents?

All MS Excel Shortcuts Key Combinations (Mixed)-1

F4During formula typing, adjust the reference type, absolute to relative, otherwise repeat the 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-sum the selected cells and place values in cells beneath.
Ctrl + Shift + $/4Currency formats the current cell
Ctrl + Shift + &/7Applies outline borders to selected cells.
Ctrl + Shift + !/1Comma formats the current cell
Ctrl + Shift + FActivates fonts drop list.
Alt + Shift + F1Insert a new worksheet.
Ctrl + Shift + PActivates font point size window.
Alt + F1Creates a chart of data in the current range.
Ctrl + F2Displays print preview window.
F3Displays the 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.

All MS Excel Shortcuts Key Combinations (Mixed)-2

Ctrl + SpacebarSelect an entire column.
Shift + SpacebarSelect the entire row.
Ctrl + Shift + SpacebarSelect the entire worksheet. If the worksheet contains data, Ctrl + Shift + Spacebar selects the current region. Pressing Ctrl + Shift + Spacebar the second time selects the current region and its summary rows. Pressing Ctrl + Shift + Spacebar the third time selects the entire worksheet.
Alt + SpacebarDisplays the Control menu for the Microsoft Office Excel window.
Shift + TabMove to the previous cell in the worksheet or move to the previous option in the dialog box.
Ctrl + TabSwitch to the next Tab in the dialog box
Ctrl + Shift + TabSwitch to the previous tab in the dialog box.
Ctrl + ENDMoves to the last cell in the worksheet, in the lowest used row of the rightmost column.  If the cursor is in the formula bar, move the cursor to the end of the text.
Ctrl + Shift + ENDExtends the selection of the cells to the last cell used on the worksheet (lower right corner). If the cursor is in the formula bar, select all the text in the formula bar from the cursor position to the end (this does not affect the height of the formula).

SEE ALSO: How to Save Web pages as PDF using Chrome?

A to Z list of all keyboard shortcut key combinations for MS Excel (Mixed)-3

Alt + EnterStarts a new line in the same cell.
Ctrl + EnterFills the selected cell range with the current entry.
Shift + EnterCompletes a cell entry and selects the cell above.
EscCancels 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 a worksheet.
Shift + Arrow KeysExtends the selection of cells by one.
Ctrl + Arrow KeysMoves to the edge of the current data region in a worksheet.
BackspaceDeletes one character to the left in the formula bar. Also clears the content of the active cell In cell editing mode, deletes one character to the left of the insertion point.
DeleteDeletes 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 the insertion point.

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

Hope you liked the above list of all MS Excel keyboard shortcuts. Here, you can also download them all in a PDF file below. If you wish to learn about MS Word keyboard shortcuts, you can check the linked article. Click the below download button to download all MS Excel shortcuts in a PDF file.

Editorial Staff

Hi there, we are the editorial staff at WINDOSPC (former HELLPC). We are a team of funny and technical people. Feel free to get in touch with us via Contact-Us page.

Leave a Reply

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

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