ExcelFunctions.net

Search Site:

The following decribes how to show formulas in Excel, for a whole worksheet, or how to just show the formula in a single Excel cell.

CTRL-` to show formulas in Excel

If you want to show the formulas in __all__ of the cells in your spreadsheet, the easiest way to do this
is through the keyboard combination:

CTRL-`

I.e. press the control key, and while this is depressed, press the ` key.

Note that the ` key is at the top left of your keyboard, next to the number 1.

To hide the formulas again, simply repeat the same key combination (i.e. press CTRL-`)

If you want to show a formula in a single Excel cell, you can do this by simply inserting an apostrophe at the start of the cell.

I.e. for a cell with the simple formula **=TODAY()** you would insert the apostrophe as follows:

'=TODAY()

This forces the cell to display the formula, rather than the result.