Formula Auditing Toolbar
This toolbar enables you to graphically display or trace the relationships between cells and formulas.
|Error Checking - Checks the active worksheet for errors. If your worksheet contains errors then the Error Checking dialog box is displayed.|
|Trace Precedents - Draws tracer arrows from the cells that supply values directly to the formula in the active cell. You can press this button multiple times to see additional levels.|
|Remove Precedent Arrows - Removes tracer arrows from one level of dependents on the active worksheet.|
|Trace Dependents - Draws a tracer arrow to the active cell from formulas that depend on the value in the active cell. You can press this button multiple times to see additional levels.|
|Remove Dependent Arrows - Removes tracer arrows from one level of dependents on the active worksheet.|
|Remove All Arrows - Removes all tracer arrows from the active worksheet.|
|Trace Error - Traces cells with error values. If the active cell contains an error value then tracer arrows are drawn to the cells that may have caused the error.|
|New Comments - Inserts a comment in the active cell. For more information about comments, please refer to the Comments page.|
|Circle Invalid Data - Draws red circles around any cells that contain values that are outside the limits you set by using Data Validation. To see what data restrictions and messages are in effect for a cell, click the circled cell, and then select (Data > Validation). For more information, see the Data Validation section.|
|Clear Validation Circles - Removes circles around cells that contain values outside the limits you set by selecting (Data > Validation). To see what data restrictions and messages are in effect for a cell before you remove circles, click the circled cell, and select (Data > Validation).|
|Show Watch Window - Displays the Watch Window that can be used to keep a close eye on certain formulas as you make changes to other parts of the worksheet.|
|Evaluate Formula - Displays the (Tools > Formula Auditing > Evaluate Formula) dialog box that enables you to evaluate parts of a formula.|
The quickest way to display the Formula Auditing toolbar is by selecting (View > Toolbars) or by right clicking on any grey area of a toolbar.
Alternatively you can select (Tools > Formula Auditing > Show Formula Auditing Toolbar).
To trace the cells that supply values indirectly to the formula in the active cell, click the Trace Precedents button again.
To add additional levels of indirect dependents, click the Trace Dependents button again.
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext