Differences

This shows you the differences between two versions of the page.

--- shortcuts_on_excel [2024/04/15 11:05] – [Wi-Fi/Internet] lorraineit
+++ shortcuts_on_excel [2024/04/15 11:57] (current) – [Number Formatting Shortcuts] lorraineit
@@ Line 1: / Line 1: @@
+ --- //[[it@lorraineschool.co.za|LorraineIT]] 2024/04/15 11:10//
+====== Excel Shortcuts ======
+----
 ===== General Excel Shortcuts =====
@@ Line 16: / Line 23: @@
 |**Close Excel** |Alt + F4|
-===== Wi-Fi/Internet =====
+===== 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 + !   |