meta data for this page
This is an old revision of the document!
— LorraineIT 2024/04/15 11:10
Excel Shortcuts
General Excel Shortcuts
| TITLE | SHORTCUT |
|---|---|
| Open a workbook | CTRL + O |
| Create a new workbook | CTRL + N |
| Save a workbook | CTRL + S |
| Save As | F12 |
| Print a workbook | CTRL + P |
| Open print preview | CTRL + F2 |
| Help | F1 |
| Activate tell me field | CTRL + 0 |
| Spell check | F7 |
| Calculate worksheets | F9 |
| Create absolute reference | F4 |
| Close a workbook | CTRL + W |
| Close Excel | Alt + F4 |
Editing Shortcuts
| TITLE | SHORTCUT |
|---|---|
| Cut | CTRL + X |
| Copy | CTRL + C |
| Paste | CTRL + V |
| Undo | CTRL + Z |
| Redo | CTRL + Y |
| Find | CTRL + F |
| Replace | CTRL + H |
| Edit active cell | F2 |
| Clear all cell contents | Delete |
Navigation Shortcuts
| TITLE | SHORTCUT |
|---|---|
| Move between cells | ← ↓ → ↑ |
| Move one cell right | TAB |
| Move one cell left | SHIFT + TAB |
| Move one cell up | SHIFT + ENTER |
| Move one cell down | SHIFT + W |
| Move down one screen | PAGE DOWN |
| Go to first cell of active row | HOME |
| Enable end mode | End |
| Move to cell A1 | CTRL + HOME |
| Move to last cell | CTRL + END |
Table and Filters Shortcuts
| TITLE | SHORTCUT |
|---|---|
| Insert table | CTRL + T |
| Toggle auto filler | CTRL + SHIFT + L |
| Activate filter | ALT + ↓ |
| Select table row | SHIFT + SPACEBAR |
| Select table column | CTRL + SPACEBAR |
| Select entire table | CTRL + A |
| Clear slider filter | ALT + C |
| Toggle table total row | CTRL + SHIFT + T |
Number Formatting Shortcuts
| TITLE | SHORTCUT | |
|---|---|---|
| Apply general format | CTRL + SHIFT + - | |
| Apply currency format | CTRL + SHIFT + $ | |
| Apply percentage format | CTRL + SHIFT + % | |
| Apply scientific format | CTRL + SHIFT + | |
| Apply date format | CTRL + SHIFT + # | |
| Apply time format | CTRL + SHIFT + @ | |
| Apply number format | CTRL + SHIFT + ! | |