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!