Here are 22 keyboard shortcuts varying in usefulness.
Cell Formatting
| Shortcut | What it does: | Usefulness | |
|---|---|---|---|
| Ctrl+Shift+& | Applies the outline border to the selected cells. | ||
| Ctrl+Shift_ | Removes the outline border from the selected cells. | ||
| Ctrl+1 | Displays the Format Cells dialog box. |
Adding and Editing a Comment
| Shortcut | What it does: | Usefulness | |
|---|---|---|---|
| Shift+F2 | Adds or edits a cell comment. |
Date
| Shortcut | What it does: | Usefulness | |
|---|---|---|---|
| Ctrl+Shift+# | Applies the Date format with the day, month, and year. | ||
| Ctrl+; | Enters the current date. |
File Commands
| Shortcut | What it does: | Usefulness | |
|---|---|---|---|
| F12 | Displays the Save As dialog box. |
Number Formatting
| Shortcut | What it does: | Usefulness | |
|---|---|---|---|
| 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+^ | Applies the Scientific number format with two decimal places. | ||
| Ctrl+Shift+! | Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. |
Text Formatting
Time
| Shortcut | What it does: | Usefulness | |
|---|---|---|---|
| [email protected] | Applies the Time format with the hour and minute, and AM or PM. | ||
| Ctrl+Shift+: | Enters the current time. |
Summary
Keyboard shortcuts allow you to perform nearly every command in Excel without moving your hand back and forth to the mouse from the keyboard. Learning and using a few shortcuts can make your work much more efficient.