Microsoft Office Tutorials and References
In Depth Information
Check for Formula Errors in a Worksheet
Chapter 4: Getting More Out of Formulas
Excel displays the smart
tag options.
5 Click the command that
fixes the formula.
Note: The name of the command
depends on the error. You only see
this command if Excel can fix the
error.
5
If the formula is not an
error, you can click
Ignore Error, instead.
Excel adjusts the formula.
Excel removes the error
indicator from the cell.
6 Repeat steps 1 to 5 until
you have checked all
your worksheet formula
errors.
Customize It!
To pick and choose which error-checking
rules you want Excel to enforce, click the
File icon, click Options to display the
Excel Options dialog box, and then click
the Formulas tab. (Alternatively, click an
error smart tab and then click Error
Checking Options in the drop-down list
that appears.) In the Error Checking
Rules section, click to deselect the check
box of any rule you do not want Excel to
enforce. Click OK.
Customize It!
If your workbook uses green colors for text
or cell backgrounds, or if you have clip art,
SmartArt, or other graphics that use a great
deal of green, then you might not notice
the error indicators. To use a different color,
click the File icon, click Options to display
the Excel Options dialog box, and then click
the Formulas tab. In the Error Checking
section, use the Indicate Errors Using This
Color list to click the color you prefer, and
then click OK.
 
Search JabSto ::




Custom Search