How To Enable Error Checking In Excel
To enable error checking in Excel, follow these steps:
Open the Excel spreadsheet that you want to enable error checking for.
Click on the "File" tab in the top-left corner of the Excel window.
In the menu that appears, click on "Options." This will open the "Excel Options" window.
In the "Excel Options" window, click on the "Formulas" option on the left-hand side of the window.
On the right-hand side of the window, under the "Error Checking" heading, make sure that the "Enable background error checking" box is checked.
If you want to enable error checking for specific types of errors, you can also check the boxes next to the different error types that you want to check for (e.g. "Numbers formatted as text or preceded by an apostrophe," "Formulas referring to empty cells," etc.).
When you're finished, click "OK" to save your changes and enable error checking in Excel.
From now on, Excel will automatically check your spreadsheet for errors and display any errors it finds in a small pop-up window. You can then click on the error message to see more details and fix the error in your spreadsheet.
And if this article about How To Enable Error Checking In Excel hasn't satisfied you yet, you can watch the video below.
That's all from SmashinGeeks, see you in another article. ^^
Tags:
Article