{"id":1459,"date":"2012-12-05T14:21:55","date_gmt":"2012-12-05T14:21:55","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1459"},"modified":"2026-04-05T00:57:42","modified_gmt":"2026-04-05T00:57:42","slug":"use-the-error-checker-tool-in-excel","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/use-the-error-checker-tool-in-excel\/","title":{"rendered":"Use the Error checker tool in Excel"},"content":{"rendered":"<p>Error checking is part of Excel&#8217;s auditing tools. \u00a0It is set up to check your formulas for errors.<\/p>\n<p>Like spellcheck, the Error checker tool won&#8217;t necessarily find all errors, but it is a useful auditing tool as it works through your document to flag up the errors it spots.<\/p>\n<p>In the Formula tab, you have the Formula Auditing section. The Error checking tool \u00a0is included here.<\/p>\n<figure id=\"attachment_1463\" aria-describedby=\"caption-attachment-1463\" style=\"width: 237px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/12\/error-checking-excel-courses1.png\"><img decoding=\"async\" class=\"size-full wp-image-1463\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/12\/error-checking-excel-courses1.png\" alt=\"error-checking-excel-courses\" width=\"237\" height=\"82\" \/><\/a><figcaption id=\"caption-attachment-1463\" class=\"wp-caption-text\">Formula auditing in the Formulas tab<\/figcaption><\/figure>\n<p>The and it has options available to you, to tick what error checking rules you wish to use.<\/p>\n<figure id=\"attachment_1465\" aria-describedby=\"caption-attachment-1465\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/12\/tick-box-error-checking-excel-courses.png\"><img decoding=\"async\" class=\"size-medium wp-image-1465\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/12\/tick-box-error-checking-excel-courses-300x249.png\" alt=\"tick-box-error-checking-excel-courses\" width=\"300\" height=\"249\" \/><\/a><figcaption id=\"caption-attachment-1465\" class=\"wp-caption-text\">Here, you can tick the boxes to apply the rules you want the error checker to apply.<\/figcaption><\/figure>\n<p>In this dialogue box you can select the Enable Background Error Checking, which, like spellcheck, will run in the background as you work.<\/p>\n<p>You&#8217;ll know it has found an error as you get a green triangle in the corner of the cell. \u00a0A discreet reminder that you need to check something. This is called a <strong>smart tag<\/strong>, and by clicking on this you can now address the issues that the error checker has found.<\/p>\n<p>When it finds an error, It comes up with a help menu (similar to Spell check when it suggests options) so you can work through systematically.<\/p>\n<figure id=\"attachment_1464\" aria-describedby=\"caption-attachment-1464\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/12\/sample-error-checking-result-excel-courses.png\"><img decoding=\"async\" class=\"size-medium wp-image-1464\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/12\/sample-error-checking-result-excel-courses-300x128.png\" alt=\"sample-error-checking-result-excel-courses\" width=\"300\" height=\"128\" \/><\/a><figcaption id=\"caption-attachment-1464\" class=\"wp-caption-text\">Options available to you, once an error has been spotted<\/figcaption><\/figure>\n<p>If you find spellcheck useful, it doesn&#8217;t take too much of a leap of faith (perhaps a mere shuffle) to make the most of the background help with your formulas.Tick the boxes and let it do the work. \u00a0For more <a href=\"\/microsoft\/excel-advanced-courses.php\">advanced techniques covered in our advanced Excel course<\/a>\u00a0take a look at what we can help you with.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Error checking is part of Excel&#8217;s auditing tools. \u00a0It is set up to check your formulas for errors. Like spellcheck, the Error checker tool won&#8217;t necessarily find all errors, but it is a useful auditing tool as it works through your document to flag up the errors it spots. In the Formula tab, you have [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"singular-low-link.php","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[192,262,263],"class_list":["post-1459","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-excel-courses","tag-formula-auditing-tools","tag-formula-error-checking"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1459","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1459"}],"version-history":[{"count":2,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1459\/revisions"}],"predecessor-version":[{"id":7911,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1459\/revisions\/7911"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}