Carol's Corner Office

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!

This entry was posted on Wednesday, December 9th, 2009 at 11:41 am and is filed under Excel 2003, Excel 2007, Microsoft Office, Microsoft Office Excel, Office Productivity. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.