How you can Hide Errors in Excel?

Sometimes the users face formula errors in Excel, then this means you should re-check the error source. So, if the users want to hide errors in Excel then they should read this blog. And for help, they can go to the site of MS Office via www.office.com/setup.

Method to Hide Errors in Excel:

1. Hide Error Values In A PivotTable Report:

For this, you should first click over the PivotTable report and then it will start showing PivotTable Tools. Then in Excel 2016/2013: you should go to the Analyze tab and then go to the PivotTable. Now, you should click on the arrow sign which is present next to the Options, and then select the Options button.

Now in Excel 2010/2007: Here from the Options tab, you should click on the PivotTable group. At this point, you should click on the arrow sign which is present next to Options and then select Options.

After this, you should click on the Layout & Format tab and then try the following options:

If you want to Change Error Display: Then from the Format tab, you should choose the “For error values show”. Here in the box, you should assign the value that you wish to show in place of errors. To show errors such as blank cells, you should clear all the characters which is present in the box.

To change Empty Cell Display: From the Format tab, you should choose the “For empty cells show” option. Here in the box, you should assign the value which you wish to show in place of errors.

2. Hide Error Indicators In Cells:

For this, you should select the formula cell which is having the problem. Then in Excel 2016/ 2013/ 2010, you should click on the File and then select Options and then tap on Formulas.

Now in Excel 2007, you should click on the Microsoft Office Button and the click on Excel Options and then hit on Formulas.

Here, in the opened Error Checking dialog box, you should clear the check box of Enable background error checking. For more information, click on office.com/setup.

3. Hide Error Values By Turning The Text White:

For this, you should select the cells range which has the error value. Then, you should go to the Home tab and then in the Styles group, you should click on the arrow sign which is present next to the Conditional Formatting. Now, you should click on the Manage Rules option. Here, the Conditional Formatting Rules Manager dialog box opens up on your screen. After this, you should hit to the New Rule. Now, the New Formatting Rule dialog box opens up on your screen. From Select a Rule Type section, you should click on the Format only cells that contain. Here from the Format only cells with section, you should go to the Edit the Rule Description option and then tap on the Errors. After this, you should go to the Format tab, and then hit over the Font. At last, to open up the Color list you should click on the arrow sign and then from the Theme Colors, you should choose the white color.

Through this way, you can hide errors in Excel. For more details, the user can go to the site of Microsoft via www.office.com/setup.  

check here this link: What are the Basics of MS Excel?

Leave a Reply

Your email address will not be published. Required fields are marked *