| Action | Excel shortcut |
|---|
| 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+ |
No comments:
Post a Comment