Tuesday, May 15, 2012

Debugging Techniques

There are times in any Excel user's life when you're just not sure what is going on behind the scenes in your workbook. In this edition of Excel Enthusiasts, we are going to take a look at two fundamental, but Vital Techniques for investigation of this nature.

1)  Are there Formulas in My Workbook?

Rather than clicking on each cell to reveal the formula in the Formula Bar, (as you needed to do in some of the older versions of Excel), you can reveal all of this information in your entire worksheet with the Keyboard Shortcut:
Ctrl + ~
This simple keyboard combination unveils the formulas in All of your cells, from which you can then determine if there is a flaw in their construction.

2)   What If I Need to do an In-Depth Review of Precedents and Dependents?

If you need More Power in seeing what your data is doing and where it comes from, look no further than the Formula Auditing group on the Formulas tab. There you will find Trace Precedents, Trace Dependents, and even Show Formulas. The information is returned in easily-understood graphics that help you make sense of the workbook you inherited from old what’s-his-name.

These two Fundamental Tools can make your Excel life a little easier. (And who wouldn’t want that?...)

No comments: