Display formulas in their cells instead of the results (Microsoft Excel 97/2000/2002/v. X/2003)

You can easily look over the formulas in your worksheet by displaying them in their cells. It sure beats selecting them one by one to look at the formula bar (if you can remember which cells have formulas to begin with!). Fortunately, Excel includes a shortcut key to toggle the view between formula results and the actual formulas.

To change whether the formula or its results display in your worksheet cells, just press [Ctrl]~ (tilde character). When you press the shortcut key again, it toggles the view back to its original display. Also, when you display the actual formula, the worksheet's column widths increase to accommodate the formula lengths.