Home / Blog / How to Hide Error Values and Indicators in Microsoft Excel

How to Hide Error Values and Indicators in Microsoft Excel

Excel Logo

Your Excel formulation can sometimes produce errors that don’t want fixing. Nonetheless, these errors can look untidy and, extra importantly, cease different formulation or Excel options from working appropriately. Happily, there are methods to cover these error values.

Conceal Errors with the IFERROR Operate

The best technique to disguise error values in your spreadsheet is with the IFERROR operate. Utilizing the IFERROR operate, you may substitute the error that’s proven with one other worth, and even another components.

On this instance, a VLOOKUP operate has returned the #N/A error worth.

#N/A error shown from VLOOKUP

This error is because of there not being an workplace to search for. A logical motive, however this error is inflicting issues with the entire calculation.

The IFERROR operate can deal with any error worth together with #REF!, #VALUE!, #DIV/0!, and extra. It requires the worth to test for an error and what motion to carry out as a substitute of the error if discovered.

Requirements of the IFERROR function

On this instance, the VLOOKUP operate is the worth to test and “0” is displayed as a substitute of the error.

IFERROR function to display 0 instead of error

Utilizing “0” as a substitute of the error worth ensures the opposite calculations and doubtlessly different options, resembling charts, all work appropriately.

Error values hidden with IFERROR

Background Error Checking

If Excel suspects an error in your components, a small inexperienced triangle seems within the top-left nook of the cell.

Green indicator of possible Excel error

Notice that this indicator doesn’t imply that there’s positively an error, however that Excel is querying the components you’re utilizing.

Excel routinely performs quite a lot of checks within the background. In case your components fails certainly one of these checks, the inexperienced indicator seems.

Once you click on on the cell, an icon seems warning you of the potential error in your components.

Smart tag for error options

Click on the icon to see totally different choices for dealing with the supposed error.

Options for handling the error

On this instance, the indicator has appeared as a result of the components has omitted adjoining cells. The listing offers choices to incorporate the omitted cells, ignore the error, discover extra info, and in addition change the error test choices.

To take away the indicator, you should both repair the error by clicking “Replace Method to Embody Cells” or ignore it if the components is right.

Flip Off the Excel Error Checking

If you don’t want Excel to warn you of those potential errors, you may flip them off.

Click on File > Choices. Subsequent, choose the “Formulation” class. Uncheck the “Allow Background Error Checking” field to disable all background error checking.

Error checking options

Alternatively, you may disable particular error checks from the “Error Checking Guidelines” part on the backside of the window.

By default, all the error checks are enabled besides “Formulation Referring to Empty Cells.”

Turn off specific error checking rules

Extra details about every rule will be accessed by positioning the mouse over the data icon.

More information on error checks

Test and uncheck the containers to specify which guidelines you prefer to Excel to make use of with the background error checking.

When components errors don’t want fixing, their error values ought to be hidden or changed with a extra helpful worth.

Excel additionally performs background error checking and queries errors it thinks you’ve made together with your formulation. That is helpful however particular or all error checking guidelines will be disabled in the event that they intrude an excessive amount of.

About Alan Murray

Check Also

How to Troubleshoot Bluetooth Issues on a Mac

Bluetooth provides you the liberty to make use of gadgets like keyboards and headphones wirelessly, …

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.