Essential key shortcuts excel

COPY PASTE
Std Excel :
ctrl + V : paste ‘normal’ (clipboard ; retains formating )
ctrl + alt + V : open paste special dialogue

shift + F2 open “insert new commen” dialogue

FILTERS
Std Excel :
- Ctrl+Shift+L : turn filters on/off
- select header with filter , then : alt+ pijl nr beneden : opent ddlb met data choices
- Alt+Down Arrow + C : clear the filters in the selected column.
- Alt+A+C is the keyboard shortcut to clear all the filters in the current filtered range.
AHK (excel specific) :
- shift + scroll lock : clears data filter on column B
(on category for AHK export shortcut list)