|
Training Index l How
errors happen l Vital Tips
Auditing Toolbar:
To load you auditing toolbar perform the following:
- Click on View > Toolbars > Formula Auditing
Note:
If you don’t see the Formulae auditing option, look in
the customised option. In some versions of Excel it is referred
to as the Auditing Toolbar. |
 |
What should pop up on the auditing toolbar is shown below (or similar depending
on which version of Excel you are using). I highly recommend that you
anchor the auditing toolbar amongst the other permanent toolbars as this will be
a vital component of any spreadsheet work (development or review).
The benefit of this auditing toolbar tool is that it visually identifies
and can trace links across different sheets and even different workbooks.
The only requirement is that the workbooks are open at the same time.The
meaning and use of the buttons are as follows:
| Trace Precedents: |
 |
Visually identifies the cells used in the formula
being reviewed. If the cell is on a different sheet or workbook,
a dotted line will appear. Double click the dotted line and chose
the reference you want to see and you will be taken there.
|
| Trace Dependents |
 |
Visually identifies the cells that depend on the
current cell. As with the Precedent button, this can span across
a workbook to other workbooks as long as all related workbooks are
open. This can be used when deleting cells to ensure that the cell
is not used elsewhere in the spreadsheet.
|
| Remove arrows: |
 |
Eventually it will become confusing with all the
arrows on the spreadsheet. Use this button to remove all the arrows.
|
| Comments tool: |
 |
| Allows you to quickly insert a comment. |
|
