Friday 25 October 2019

Embracing Excel's keyboard shortcuts

As subscribers to my Excel e-tips mailing list will know, I’m a big fan of keyboard shortcuts – they save a lot of time in Excel compared to using the mouse. In fact, there are two types of shortcut:
  • Direct shortcuts
  • Indirect shortcuts
Direct shortcuts
These are accessed by pressing CTRL + another key. For example, press CTRL+X and you’ll cut the info from a cell; CTRL+V will paste.

Indirect shortcuts
These are accessed by a combination of keys pressed in sequence (rather than at the same time). For example, Alt>H>A>C will centre-align the content of a cell.

Over the next few weeks, my challenge to myself is to persuade you to put down the mouse, embrace both types of keyboard shortcut, and make the journey towards working more efficiently in Excel.

To keep up with this series, add your email to the "follow by email" box on the right to subscribe to the blog, or sign up to Naturally Spreadsheets' Excel e-tips mailing list to get the tips delivered straight to your inbox every 2 weeks.