meta data for this page
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| shortcuts_on_excel [2024/04/15 11:15] – [Wi-Fi/Internet] lorraineit | shortcuts_on_excel [2024/05/15 08:45] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| --- // | --- // | ||
| + | |||
| + | ====== Excel Shortcuts ====== | ||
| + | |||
| + | |||
| + | ---- | ||
| ===== General Excel Shortcuts ===== | ===== General Excel Shortcuts ===== | ||
| Line 19: | Line 24: | ||
| ===== Editing Shortcuts ===== | ===== 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** | ||
| + | |**Apply currency format** | ||
| + | |**Apply percentage format** |CTRL + SHIFT + % | | ||
| + | |**Apply scientific format** |CTRL + SHIFT + ^ | ||
| + | |**Apply date format** | ||
| + | |**Apply time format** | ||
| + | |**Apply number format** | ||
| + | |||
| + | |||
| + | |||