

By clicking on “Error Checking” the above shown window will be opened. Let’s have a look at each button:
(1) “Help on this Error” opens some help text
(2) With “Show Calculation Steps” you can follow up the calculation process in detail
(3) With “Ignore Error” you’ll move to the next found error and this one won’t be regarded any further
(4) “Edit in Formula Bar” lets you jump into the formula bar so that you can correct any error right away
(5) With Cancel, Previous and Next you can navigate between the errors in the workbook or stop the checking
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.