Microsoft Office Tutorials and References
In Depth Information
Use Formula Auditing
The Name Manager is another dialog box that can be displayed by clicking its
button on the Formulas tab. This dialog box lets you add, update, and delete
named areas. A really quick way to just add them (but not update or delete) is to
1. Select an area on the worksheet.
2.ClickintheNameBoxandenterthename.
The Name Box is part of the Formula Bar and sits to the left of where
formulas are entered.
3. Press Enter.
Done! Now you can use the name as you please. Figure 18-6 shows a name
being entered by using the Name Box. Of course you can use a particular
name only once in a workbook.
Figure 18-6:
Defining a
named area
the easy
way.
Use Formula Auditing
There are precedents and dependents. There are external references. There
is interaction everywhere. How can you track where the formula references
are coming from and going to?
Use the formula auditing tools, that’s how! On the Formulas tab is the
Formula Auditing section. In the section are various buttons that control the
visibility of auditing trace arrows. See Figure 18-7.
The formula auditing toolbar has a number of features for wading through
your formulas. Besides showing tracing arrows, it also can check errors,
evaluate formulas, check for invalid data, and add comments to worksheets.
Search JabSto ::




Custom Search