Show Formulas In Excel


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.


Show All Formulas in a Spreadsheet

Key to show formulas
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 (see right).


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


Show Formulas in a Single Cell

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.

Return to the Basic Excel Page

Return to the ExcelFunctions.net Home Page

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net