Ctrl + Plus (# pad) – Insert Row / Insert Column.Ctrl + Arrowkey – Jump to Edge of Content.Navigating through Excel spreadsheet could be time-consuming, especially if you are dealing with a large data-set. Ctrl + Alt + V – Paste special, will trigger the prompt for more options.Alt + W + Q – Zoom in (type in % zoom, helpful with large dataset).Alt + H + 9 – Remove one decimal * requires pressing all keys at the same time.Alt + H + 0 – Add one decimal * requires pressing all keys at the same time.F2 + F9 – Show as input number *useful for checking numbers but press ESC after (or you’ll change formulas into an input).F2 – Edit Cell, Show Formula (avoiding double-click).The key is to minimize the use of the mouse and do as much as you can with the keyboard to save you time and improve accuracy. Start with some basic and most frequently used ones in all kind Excel workflow.

If you work with Excel on a daily basis, it’s worth spending an extra 10 minutes to sharpen and improve on your shortcut games, because this 10 minutes investment will pay back exponentially in no time.

Cheat sheet excel shortcut keys