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:18] – lorraineit | shortcuts_on_excel [2024/05/15 08:45] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 35: | Line 35: | ||
| |**Edit active cell** |F2| | |**Edit active cell** |F2| | ||
| |**Clear all cell contents** |Delete| | |**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** | ||
| + | |||
| + | |||
| + | |||