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.