This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Hide Error Cells When Printing
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?
Figure 1197 A few nagging error cells.
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>.
Figure 1198 Select to print error cells as blank.
Results: Although the error will still appear in the worksheet, when you print, the error cells will print as blanks.
Figure 1199 No errors will show in the printed document.
Alternate Strategy: The ultimate way to solve this problem is to change the formula to test whether the divisor is zero. In this case, a proper formula would be =IFERROR(B2/C2,0). In Excel 2003, use =IF(C2=0,“",B2/C2).