Using Excel like a pro: Keyboard shortcuts

There is this old story about junior bankers that they don’t get a mouse with their laptop during their first weeks, forcing them to learn all the Excel keyboard shortcuts. Whether this story is true or not, it might be a pretty good way for you remember all the shortcuts and speed up your Excel skills.

Here is an example of three keyboard shortcuts I often use in Excel. Especially the paste special > values shortcut is a useful one to know.

Head over to macabacus for the full list of useful Excel shortcuts. The website includes a pdf file with a list of the most important Excel shortcuts to have on hand. The website also includes some macros and custom tool bars, but they seem mainly aimed people working in finance making financial models. You are welcome to share macros and other Excel resources in the comments below.

3 thoughts on “Using Excel like a pro: Keyboard shortcuts

  1. When I type / in a cell, even one formatted as text, I get a row of numbers and letters in little squares sitting on the toolbars. What is that a shortcut to, and why no Alt or Ctrl key? When I type it in the formula bar, it’s fine.

  2. Interesting. I just checked it out and yes I get the same. Pressing / activates the shortcut menu as ur saying ‘the letters and numbers appear as overlay on the menu’. U can type the / in the formula bar or just double click the selected cell to type it in there.