Toggling between values and formulae

For most people, the only way to see the formula in a cell is to click on the cell. You can then see the formula in the bar immediately below the ribbon. Hit F2 and you can start editing that formula.

But there's a little-known way of seeing all formulae across the entire sheet at the same time. And it uses the mysterious key above the Tab key on most keyboards, to the left of the 1 key—the one that you've probably never touched.

If you hit CTRL and that key, then instead of showing the cells' values, the spreadsheet will display the formulae therein. Repeat the action and it will revert to the values.

It can be hugely useful when you need to audit things and generally figure out what's going on. (But don't tell anyone. Keep it up your sleeve.)

• Tweet