| Shortcut | Description |
| F2 | Edit the selected cell. |
| F5 | Goto a specific cell. For example, C6. |
| F7 | Spell check selected text and/or document. |
| F11 | Create chart. |
| Ctrl + A | Select all. |
| Ctrl + B | Bold. |
| Ctrl + C | Copy. |
| Ctrl + F | Find (same as Shift + F5). |
| Ctrl + G | Go To. |
| Ctrl + H | Replace. |
| Ctrl + I | Italic. |
| Ctrl + K | Insert link. |
| Ctrl + N | New Workbook. |
| Ctrl + O | Open Workbook. |
| Ctrl + P | Print dialog. |
| Ctrl + S | Save. |
| Ctrl + U | Underline. |
| Ctrl + V | Paste. |
| Ctrl + Z | Undo. |
| Ctrl + Y | Redo. |
| Ctrl + X | Cut. |
| Ctrl + 5 | Strikethrough text. |
| Ctrl + F3 | Define Name. |
| Ctrl + F4 | Exit Excel. |
| Ctrl + F6 | Switch between open workbooks. |
| Ctrl + F9 | Minimize current window. |
| Ctrl + F10 | Maximize current window. |
| Shift + F1 | Activate Help on Item. |
| Shift + F2 | Insert Comments |
| Shift + F3 | Insert Function. |
| Ctrl + Shift + ; | Enter the current time. |
| Ctrl + ; | Enter the current date. |
| Ctrl + Page down | Move to next worksheet. |
| Ctrl + Page up | Move to previous worksheet. |
| Ctrl + Shift + # | Number Format: Date |
| Ctrl + Shift + @ | Number Format: Time. |
| Ctrl + Shift + ! | Number Format: Commas. |
| Ctrl + Shift + $ | Number Format: Currency |
| Ctrl + Shift + % | Number Format: Percentage |
| Ctrl + Shift + ^ | Number Format: Scientific. |
| Ctrl + Space | Select entire column. |
| Shift + Space | Select entire row. |
| Ctrl + (Arrow key) | Move to next section. |
Nice list, learning the shortcuts really get you ahead. I'd love to know how people go about searching and memorizing shortcuts.
ReplyDelete