Formula Auditing Toolbar
Trace precedent = it is used to trace all the values which used to generate the formula.
Select formula cell and click on it.
Remove precedent arrows = to remove arrows
Trace dependent = it is used to trace all formulas which is dependent on current numeric data cell
Remove trace dependent arrows = it removes the arrows. it is printable, it removes the all arrows.
Remove all arrows = it is used to remove all arrows.
Trace errors = trace all errors on the sheet.
Evaluate formulas = To View the steps of the error in the formula.
Show watch window = this shows the detail list of the cell information, its book name, sheet name, cell address, formula and its value.
Show watch window is common for all windows
Circle Invalid data = This will circle out those data which validate the validation, apply where you set validations on already written data (not printable)
Clear Validation circle = to clear the validation circle.
Comment = it is used to insert new comment on the cell.
No comments:
Post a Comment