--- //[[it@lorraineschool.co.za|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 + !   |