Hide Error Cells When Printing
October 3, 2023 - by Bill Jelen
Problem: I have a formula that does division. Occasionally, the divisor cell is zero, so I have a couple of
#DIV/0! value errors. I need to print this sheet without the errors to get the report to a staff meeting. I don’t have time to rewrite all the formulas to test whether the divisor is zero. What can I do?
Strategy: From the Page Layout tab, you can select the dialog launcher at the bottom right corner of the Page Setup group. In the Page Setup dialog, you go to the Sheet tab, select the dropdown for (Print) Cell Errors As, and select <blank>.