Microsoft Office Tutorials and References
In Depth Information
Telling Excel Which Errors to Flag
You have learned a lot about the types
of errors Excel typically flags, and why it flags
them as errors. You may prefer to not have
certain errors flagged as such, especially if you
use workbooks in which they would not be
considered actual errors.
To tell Excel which errors you want it to watch
out for, follow these steps:
1. Click the File tab to display Backstage.
2. Select Options from the list on the left.
The Excel Options dialog box appears.
3. Select Formulas from the list on the left.
The Formula options appear on the right,
as shown in Figure 4-2.
Errors are ﬂagged with a triangle marker if
you set up Excel to do that (see the section
“Telling Excel to Flag Result Cells with an
Error” for help). Regardless, if a formula is
considered to be in error, Excel can point it
out to you during an error check (see the
section, “Checking for Errors Automatically
One at a Time”). The errors that Excel ﬂags
with a marker or during an error check are
partially determined by the “rules” you
select by following the steps given here.
Select the Errors Excel
Should Watch For
Tell Excel which errors you want it to look for.