
| General Shortcuts | |
| Create New Workbook | CTRL N |
| Open Existing Workbook | CTRL O |
| Save Workbook | CTRL S |
| Save Workbook As | F12 |
| Print Workbook | CTRL P |
| Spell Check Workbook | F7 |
| Excel Help Menu | F1 |
| Data Entry Shortcuts | |
| Start a new line in the same cell | ALT ENTER |
| Edit the active cell | F2 |
| Start a formula | = |
| Insert AutoSum formula | ALT = |
| Enter current date | CTRL ; |
| Enter current time | CTRL SHIFT : |
| Insert a hyperlink | CTRL K |
| Cut | CTRL X |
| Copy | CTRL C |
| Paste Once | ENTER |
| Paste multiple times | CTRL V |
| Copy formatting | CTRL SHIFT C |
| Paste formatting only | CTRL SHIFT V |
| Copy valule from the cell above | CTRL SHIFT " |
| Clear selected cell contents | DELETE |
| Delete selected cells | CTRL - |
| Repeat last command | F4 |
| Cancel data entry | ESC |
| Undo | CTRL Z |
| Moving Around Shortcuts | |
| Move to next cell down and accept data entry | ENTER |
| Move to previous cell up and accept data entry | SHIFT ENTER |
| Move one cell right and accept data entry | TAB |
| Move one cell left and accept data entry | SHIFT TAB |
| Move one cell up,down,left, or right | ↑ ↓ ← → |
| Move to edge of current data region | CTRL ↑ ↓ ← → |
| Move to beginning of row | HOME |
| Move to beginning of worksheet | CTRL HOME |
| Move to last used cell on worksheet | CTRL END |
| Down one screen | PAGE DOWN |
| Up one screen | PAGE UP |
| One screen to right | ALT PAGE DOWN |
| One screen to left | ALT PAGE UP |
| Next sheet in workbook | CTRL PAGE DOWN |
| Previous sheet in workbook | CTRL PAGE UP |
| Go To | F5 |
| Find | SHIFT F5 or CTRL F |
| Find Next | SHIFT F4 |
| Selecting Ranges | |
| Select the entire column | CTRL SPACEBAR |
| Select the entire row | SHIFT SPACEBAR |
| Select the entire worksheet | CTRL A |
| Select all objects on sheet | CTRL SHIFT SPACEBAR |
| Formatting Shortcuts | |
| Format Cells dialog box | CTRL 1 |
| General number format | CTRL SHIFT ~ |
| Currency format | CTRL SHIFT $ |
| Percentage format | CTRL SHIFT % |
| Date format | CTRL SHIFT # |
| Time format | CTRL SHIFT @ |
| Bold | CTRL B |
| Italics | CTRL I |
| Underlining | CTRL U |
| Strikethrough | CTRL 5 |
| Hide rows | CTRL 9 |
| Unhide rows | CTRL SHIFT ( |
| Hide columns | CTRL 0 (zero) |
| Unhide columns | CTRL SHIFT ) |

