Excel Keyboard Shortcuts

This is one of our biggest Excel keyboard shortcut compilation! Microsoft Excel is a powerful tool which has many Excel keyboard shortcuts to make you more efficient!
Instead of memorizing all of these useful Excel keyboard shortcuts, we have compiled an exhaustive list for you so you can apply to your Excel worksheet straight away.
Check out this free video tutorial to see all of the 333 Excel Keyboard Shortcuts in action! Alongside with the video is we have included a downloadable cheat sheet for you so that you can print out all of the Excel Shortcuts right on your desk!

CTRL + SHIFT + ARROWS: Move / Highlight Cells

If you want to quickly move to the last cell of your table/data you can press CTRL + ↔ ↕.
If you want to quickly highlight up to the last cell of your table/data you can press CTRL + SHIFT + ↔ ↕.

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 :)

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).