shortcuts_on_excel
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:43] – [Navigation Shortcuts] lorraineit | shortcuts_on_excel [2024/04/15 11:57] (current) – [Number Formatting Shortcuts] lorraineit | ||
|---|---|---|---|
| Line 50: | Line 50: | ||
| |**Move to cell A1** |CTRL + HOME| | |**Move to cell A1** |CTRL + HOME| | ||
| |**Move to last cell** |CTRL + END| | |**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** | ||
| + | |||
| + | |||
shortcuts_on_excel.1713174235.txt.gz · Last modified: 2024/04/15 11:43 by lorraineit