Page 19 of 23PREVNEXT

So that's how! Printing options in Excel

Error value displayed, and error value replaced with a blank cell

You can keep a formula error value from appearing when you print.

Perhaps you're just about to print your worksheet when you notice that it contains a few formula error values, such as #DIV/O, #REF!, or #NAME?. If you don't have time to fix the errors, and you don't want them to appear in your printout, you can quickly replace them so that they are not displayed.

If you are in print preview, click Setup. (In normal view, on the File menu, click Page Setup). In the Page Setup dialog box, click Sheet. Under Print, in the Cell errors as box, select how you want the cell errors to appear. Your choices are: a blank cell, a double dash, or "#NA".

Page 19 of 23PREVNEXT