Microsoft Office Tutorials and References
In Depth Information
Fixing Formulas
Figure 18-1:
Setting
options.
Figure 18-2:
Viewing
formulas the
easy way.
Fixing Formulas
Suppose your worksheet has some errors — don’t panic! It happens to
even the savviest users, and Excel can help figure out what’s going wrong.
On the Formulas tab in the Formula Auditing section is the Error Checking
button. Clicking the button displays the Error Checking dialog box shown in
Figure 18-3. That is, the dialog box appears if your worksheet has any errors.
Otherwise, it just pops up a message that the error check is complete. It’s
that smart!
Search JabSto ::




Custom Search