Error Checking

Double click on the arrows to move between the linked cells.
When you press F2 the precedents of the active cell are highlighted in Blue if the following Options(Edit tab, "Edit directly in cell) is not checked.
This dialog box is probably the quickest way to identify any cells that contain errors on the active worksheet.

Error Checking - If your worksheet contains errors then the Error Checking dialog box is displayed.

You can also display the Error Checking dialog box by selecting (Tools > Error Checking).
This can help you to work out why a formula is returning an error and help you to identify the cause.
When Excel cannot properly evaluate a formula it will display one of the default error values (#DIV/0!, #VALUE! etc).
There is a Trace Error button on the auditing toolbar that can be used to detect any formulas that returns an error.
Clicking once will trace all the arrows to cells with error values. You should remove any trace arrows before using.

Using the (Tools > Error Checking) dialog box

This dialog box is completely modeless and will only be displayed if the active worksheet contains an error.
The first cell that contains an error will be selected and the dialog box will be displayed.
The actual contents of the cell are displayed in the top left corner and a short description of the error is given below, in this case it is division by zero.

Help on this error - Displays a help topic relating to the specific type of error.
Show calculation steps - Displays the Evaluate Formula dialog box.
Ignore error - This will remove the green indicator from the top left hand corner of the cell containing the current error.
Edit in formula bar - Allows you to edit the formula in the formula bar. Press Resume to continue after you have made the changes.
Options - Displays the (Tools > Options)(Error Checking tab).
You can use the Previous and Next buttons to move between the errors on the active worksheet.

Getting Help

A message box will be displayed once the whole worksheet has been checked.


You can choose not to ignore any errors by using the Options dialog box and clicking "Reset Ignored Errors".
If you have chosen to ignore the error by accident, pressing F2 and Enter will display the error indicator again

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext