Keyboard shortcuts 7: Inserting a new worksheet

Here’s another easy yet useful keyboard shortcut for you – inserting a new worksheet into your Excel workbook. Your shortcut is Shift + F11. Go on – try it now!

Keyboard shortcuts 6 – Save As

Another really helpful keyboard shortcut this week… The Save As… function is one of the most-used in Excel, but it can be fiddle to do, especially in newer versions of Excel where there are multiple mouse clicks required to find your hard drive, network area, etc. So, from now on, all you need to do is press the F12 key, and you’re there!

Keyboard shortcuts 5: Copying the formula from the cell above

Here’s another nice formula – particularly good as it saves you having to re-type, or copy-and-paste, a formula to the cell below. A simply CTRL + ‘ will copy the formula from the cell above and put it in the cell you’re on.

Keyboard shortcuts 4: Closing a workbook

Finished working on an Excel workbook and want to move onto the next thing? Close it quickly and easily with CTRL+W – and if you’ve not saved it yet, Excel will ask you if you want to.

But don’t use the mouse – just press Enter to save!