Using error checker in Excel

When inserting formulas into Excel, it is likely that you may make some errors.

So instead of going over and over your work trying to make sure there are no errors yourself, Excel has a useful tool for error checking. First you need to know how to enable or disable error checking.

All you need to do is go to the ‘File’ menu and select ‘Options’.

In ‘Excel Options’ click on ‘Formulas’ then find the ‘Error checking rules’ here you need to check ‘Cells containing formulas that result in an error’ to enable error checking.

Excel Training - Error Checking
Then you need to check ‘Enable background error checking’

If you want to disable error checking all you need to do is clear ‘Cells containing formulas that result in an error’.

You can also check or clear other options to do more for error checking.

Click ‘OK’ and you now have a handle little tool ready to check your errors!

If you would like to learn about Excel and how to make the most of its error checking features we can show you on one of our Excel courses

Share on LinkedInShare on FacebookTweet about this on TwitterShare on Google+Email this to someone