List of All Microsoft Excel Keyboard Shortcuts
Microsoft 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 Microsoft Excel shortcuts or key combinations 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.
SEE ALSO: List of all Microsoft Office Word Shortcut Key Combinations
Microsoft Excel Shortcut Key Combinations
Here, 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 + A | Select All |
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 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 “Insert Hyperlink” window for new hyperlink or Opens “Edit Hyperlink” window for selected existing hyperlink. |
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 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)
Ctrl + PageUp | Switches between worksheet tabs from left to right. |
Ctrl + PageDown | Switches between worksheet tabs from right to left. |
Ctrl + Shift + ( | Unhides any hidden rows within selection. |
Ctrl + Shift + ) | Unhides any hidden columns within selection. |
Ctrl + F5 | XL, 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 new worksheet |
Ctrl + Shift + TAB | To 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. |
SEE ALSO: How to Password Protect your MS Office Documents?
All MS Excel Shortcuts Key Combinations (Mixed)
F4 | During 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 + F2 | Edits a cell comment. |
Alt + F8 | Opens macro dialog box. |
Alt + +/= | Auto sums selected cells and place values in cells beneath. |
Ctrl + Shift + $/4 | Currency formats current cell. |
Ctrl + Shift + &/7 | Applies outline borders to selected cells. |
Ctrl + Shift + !/1 | Comma formats current cell. |
Ctrl + Shift + F | Activates fonts drop list. |
Ctrl + Shift + P | Activates fonts point size window. |
Alt + F1 | Creates a chart of data in current range. |
Alt + Shift + F1 | Inserts a new worksheet. |
Ctrl + F2 | Displays print preview window. |
F3 | Displays 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. |
Ctrl + Spacebar | Selects an entire column. |
Shift + Spacebar | Selects the entire row. |
Ctrl + Shift + Spacebar | Selects 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 + Spacebar | Displays the Control menu for the Microsoft Office Excel window. |
Shift + Tab | Moves to previous cell in worksheet or move to previous option in dialog box. |
Ctrl + Tab | Switches to next Tab in dialog box. |
Ctrl + Shift + Tab | Switches 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). |
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)
Alt + Enter | Starts a new line in the same cell. |
Ctrl + Enter | Fills the selected cell range with 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 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 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. |
A to Z list of all Microsoft Excel Keyboard Shortcuts in PDF file
Hope you liked above list of all MS Excel keyboard shortcuts. Here, you can also download them all in PDF file from below. If you wish to learn about MS Word keyboard shortcuts, you can check linked article. Click below download button to download all MS Excel shortcuts in pdf file.