F4: Repeat Last Action If you want to repeat a previous action, like inserting a column/row, formatting cells, copy & pasting etc, then you can use the F4 keyboard shortcut which will repeat your last action (in most cases).
CTRL + SHIFT + L: Insert a Filter in Excel To insert a filter in Excel using a keyboard shortcut you need to click in a column heading and press CTRL+SHIFT+L
To un-filter, you need to press this shortcut again. I use this shortcut all the time :)
CTRL + SHIFT + END: Select All Your Data When you have lots of data on a workbook and it is spread out over the page with some blank columns or rows, a great way to select and highlight all your data is to use the CTRL+SHIFT+END keyboard shortcut.
This will extend the selection to the last used cell on the worksheet ...
CTRL + ENTER: Fill Down If you want to make a change to a cell and reflect that change to a selection of cells, then pressing CTRL + ENTER will fill down or copy your action to the selected cells.