Microsoft Excel: Hide Error Cells When Printing

Problem: You have a formula that does division. Occasionally, the divisor cell is zero, so you have a couple of Div/0 value errors, as shown in Fig. 1266. You just need to print this without the errors to get the report to the staff meeting, without having to rewrite all the formulas.

See all Microsoft Excel tips

Strategy: Go to File – Page Setup. Go to the Sheet tab. There is a dropdown for (Print) Cell Errors As:. Choose this dropdown and select , as shown in Fig. 1267.

Result: Although the error will still appear in the worksheet, when you print, the error cells will print as blanks, as shown in Fig. 1268.

Alternate Strategy: Perhaps the “right” way to solve this problem is to change the formula to test if the divisor is zero. In this case, a proper formula would be =IF(C2=0,“”,B2/C2).

Summary: To print a worksheet without the error cells, change the setting on the Sheet tab of the Page Setup dialog.

Commands Discussed: File – Page Setup – Sheet

See all Microsoft Excel tips

Images