Sometimes we just need to see the formulas in our MS Excel worksheet. I have had more than one inquiry regarding this topic. When this situation presents itseld, you may want to turn on Excel’s formula display. Follow the steps below to learn how:
Simply click on Ctrl + ~ (tilde).
There is a more convoluted method of doing this in version 2003 via Tools | Options but as you all know I am all about saving time and keystrokes. In version 2007, you have the Show Formulas button in the Formula Auditing group of the Formulas tab, but as I said, why waste time and keystrokes?
If you select a cell whose formula you would like to troubleshoot before turning on the formula display feature, MS Excel will also show you the dependent cells for the formula!