Microsoft Excel keyboard shortcuts
| Description | Shortcut key |
|---|---|
| Alternates between displaying cell values and displaying formulas in the worksheet. | CTRL+` |
| Alternates between hiding objects, displaying objects, and displaying placeholders for objects. | CTRL+6 |
| Applies or removes bold formatting | CTRL+2 |
| Applies or removes bold formatting | CTRL+B |
| Applies or removes italic formatting | CTRL+3 |
| Applies or removes italic formatting | CTRL+I |
| Applies or removes underlining | CTRL+4 |
| Applies or removes underlining | CTRL+V |
| Applies the Currency format with two decimal places | CTRL+$ |
| Applies the Date format with the day, month, and year | CTRL+# |
| Applies the Exponential number format with two decimal places | CTRL+^ |
| Applies the General number format | CTRL+~ |
| Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values | CTRL+! |
| Applies the outline border to the selected cells | CTRL+& |
| Applies the Percentage format with no decimal places | CTRL+% |
| Applies the Time format with the hour and minute, and AM or PM | CTRL+@ |
| Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation | CTRL+ALT+F9 |
| Calculates all worksheets in all open workbooks | F9 |
| Calculates the active worksheet | SHIFT+F9 |
| Closes and reopens the current task pane | CTRL+F1 |
| Closes the selected workbook window | CTRL+F4 |
| Closes the selected workbook window | CTRL+X |
| Copies the selected cells | CTRL+C |
| Copies the value from the cell above the active cell into the cell or the Formula Bar" | CTRL+" |
| Creates a chart of the data in the current range | ALT+F1 |
| Creates a chart of the data in the current range | F11 |
| Cuts the selected cells | CTRL+Y |
| Displays or hides the outline symbols | CTRL+8 |
| Displays or hides the Standard toolbar | CTRL+7 |
| Displays the Create List dialog box. CTRL+N Creates a new, blank file | CTRL+L |
| Displays the Delete dialog box to delete the selected cells | CTRL+- |
| Displays the Find and Replace dialog box | CTRL+H |
| Displays the Format Cells dialog box | CTRL+1 |
| Displays the Go To dialog box | CTRL+G |
| Displays the Go To dialog box | F5 |
| Displays the Help task pane | F1 |
| Displays the Insert dialog box to insert blank cells | CTRL++ |
| Displays the Insert Function dialog box | SHIFT+F3 |
| Displays the Macro dialog box to run, edit, or delete a macro | ALT+F8 |
| Displays the Microsoft Office Clipboard | CTRL+C |
| Displays the Open dialog box to open or find a file | CTRL+O |
| Displays the Print dialog box | CTRL+R |
| Displays the Save As dialog box | F12 |
| Displays the shortcut menu for a selected item | SHIFT+F10 |
| Displays the Spelling dialog box to check spelling in the active worksheet or selected range | F7 |
| Edits a cell comment | SHIFT+F2 |
| Enters the current date | CTRL+; |
| Enters the current time | CTRL+: |
| Hides the selected columns | CTRL+0 |
| Hides the selected rows | CTRL+9 |
| Including cells not marked as needing to be calculated | CTRL+F9 |
| Inserts a new worksheet | ALT+SHIFT+F1 |
| Inserts a new worksheet | SHIFT+F11 |
| Maximizes or restores the selected workbook window | CTRL+F10 |
| Minimizes a workbook window to an icon | F10 |
| Pastes a defined name into a formula | F3 |
| Removes the outline border from the selected cells | CTRL+_ |
| Repeats the last command or action, if possible | CTRL+Z |
| Repeats the last command or action, if possible | F4 |
| Restores the window size of the selected workbook window | CTRL+F5 |
| Saves the active file with its current file name and location | CTRL+S |
| Selects all cells that contain comments | CTRL+SHIFT+O |
| Selects the current region | CTRL+A |
| Selects the entire worksheet | CTRL+A CTRL+A (two times) |
| Undo command | CTRL+U |
| Unhides any hidden columns within the selection | CTRL+ |
Displays the Create Table dialog box.
CTRL + U
Applies or removes underlining.
CTRL + SHIFT + U switches between expanding and collapsing of the formula bar.
CTRL + V
Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.
CTRL + ALT + V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
CTRL + W
Closes the selected workbook window.
CTRL + X
Cuts the selected cells.
CTRL + Y
Repeats the last command or action, if possible.
CTRL + Z
Uses the Undo command to reverse the last command or to delete the last entry that you typed.
Formulas:
| Shortcut key | Description |
|---|---|
| Alt + = | Insert the AutoSum formula. |
| Shift + F3 | Display the Insert Function dialog box. |
| Ctrl + a | Display Formula Window after typing formula name. |
| Ctrl + Shift + a | Insert Arguments in formula after typing formula name. . |
| Shift + F3 | Insert a function into a formula . |
| Ctrl + Shift + Enter | Enter a formula as an array formula. |
| F4 | After typing cell reference (e.g. =E3) makes reference absolute (=$E$4) |
| F9 | Calculate all worksheets in all open workbooks. |
| Shift + F9 | Calculate the active worksheet. |
| Ctrl + Alt + F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. |
| Ctrl + Alt + Shift + F9 | Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. |
| Ctrl + Shift + u | Toggle expand or collapse formula bar. |
| Ctrl + ` | Toggle Show formula in cell instead of values |
| Ctrl + F3 | Define a name or dialog. |
| Ctrl + Shift + F3 | Create names from row and column labels. |
| F3 | Paste a defined name into a formula. |
Post a Comment
leave a comment!