Excel Quick Tip: Toggle View Formulas

Did You Know?

Pressing Ctrl ~  in Microsoft Excel to toggle the visibility of formulas in the worksheet cells. It is the equivalent of:

  • Office 2003: Clicking Tools > Options > View Formulas checkbox
  • Office 2007 & 2010: Clicking the Formulas ribbon menu > Show Formulas button.

If you are having problems switch back to the calculated results when you press CTRL ~, check to make sure that there isn't an ' in front of the formula. If there is, remove it and press CTRL ~ again if necessary.


Leave a Reply

Your email address will not be published. Required fields are marked *