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
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)
Combination | Description |
---|---|
Ctrl + A | Select all the available rows and columns |
Ctrl + B | Bold the selected text/cell |
Ctrl + C | Copy the selected text/cell |
Ctrl + D | Uses the fill-down command to copy the contents and format of the topmost cell of a selected range into the cells below. |
Ctrl + F | Find |
Ctrl + G | Displays GOTO dialog box |
Ctrl + H | Replace |
Ctrl + I | Italicize the text |
Ctrl + J | Justify the text |
Ctrl + K | Opens the “Insert Hyperlink” window for a new hyperlink. If an existing hyperlink is selected, it opens the “Edit Hyperlink” window. |
Ctrl + N | Creates a new blank workbox |
Ctrl + O | Open an existing MS Excel Document |
Ctrl + P | Shows the Print window |
Ctrl + R | Uses 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 + S | Saves active MS Excel document with its current filename and format |
Ctrl + T | Displays the Create Table dialog box |
Ctrl + U | Underline selected text |
Ctrl + V | Paste copied text/cells |
Ctrl + W | Closes the selected workbook window |
Ctrl + X | Cut selected text/cells |
Ctrl + Y | Repeat the last action or command if possible. |
Ctrl + Z | Undo a previous action |
Ctrl + 0 | Hides the selected columns |
Ctrl + 6 | Alternates between hiding objects, displaying objects, and displaying placeholders |
Ctrl + 8 | Displays or hides the outline symbols |
Ctrl + 9 | Hides 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)
Combination | Description |
---|---|
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 + F5 | XL, and restores the window size |
Ctrl + F6 | Next workbook window |
Ctrl + Shift + F6 | Previous workbook window |
Ctrl + F9 | To minimize the workbook |
Ctrl + F11 | To Open VBE |
Ctrl + Shift + F1 | To open a new worksheet |
Ctrl + Shift + TAB | To 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
Combination | Description |
---|---|
F4 | During 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 + F2 | Edits a cell comment. |
Alt + F8 | Opens macro dialog box. |
Alt + +/= | Auto-sum the selected cells and place values in cells beneath. |
Ctrl + Shift + $/4 | Currency formats the current cell |
Ctrl + Shift + &/7 | Applies outline borders to selected cells. |
Ctrl + Shift + !/1 | Comma formats the current cell |
Ctrl + Shift + F | Activates fonts drop list. |
Alt + Shift + F1 | Insert a new worksheet. |
Ctrl + Shift + P | Activates font point size window. |
Alt + F1 | Creates a chart of data in the current range. |
Ctrl + F2 | Displays print preview window. |
F3 | Displays the paste name dialog box. |
Shift + F3 | Displays the Insert Function dialog box. |
Ctrl + F4 | Closes the selected workbook window. |
Shift + F6 | Switches between worksheet, Zoom controls, task panel, and Ribbon. |
All MS Excel Shortcuts Key Combinations (Mixed)-2
Combination | Description |
---|---|
Ctrl + Spacebar | Select an entire column. |
Shift + Spacebar | Select the entire row. |
Ctrl + Shift + Spacebar | Select 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 + Spacebar | Displays the Control menu for the Microsoft Office Excel window. |
Shift + Tab | Move to the previous cell in the worksheet or move to the previous option in the dialog box. |
Ctrl + Tab | Switch to the next Tab in the dialog box |
Ctrl + Shift + Tab | Switch to the previous tab in the dialog box. |
Ctrl + END | Moves 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 + END | Extends 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
Combination | Description |
---|---|
Alt + Enter | Starts a new line in the same cell. |
Ctrl + Enter | Fills the selected cell range with the current entry. |
Shift + Enter | Completes 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 Keys | Move one cell Up, Down, Left, or Right in a worksheet. |
Shift + Arrow Keys | Extends the selection of cells by one. |
Ctrl + Arrow Keys | Moves to the edge of the current data region in a worksheet. |
Backspace | Deletes 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. |
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 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.