Prevent error values from printing in Excel 2002!
In previous versions of Excel, you were forced to create
custom formatting or
formula solutions to avoid displaying worksheet errors
like #DIV/0! or #VALUE!
when you printed a worksheet. Excel 2002 simplifies things
by letting you
control how these errors are handled when it comes time to
print. You can
simply have the offending cells appear blank, or display a
substitute string in
place of the error.
To take advantage of this feature, select File | Page
Setup from the menu bar.
Then, click on the Sheet tab. Finally, select one of these
choices from the
Cell Errors As dropdown list:
Displayed
<blank>
--
#N/A
Click OK when you've finished. Choosing Displayed
prints the original error
value, while the other choices replace the errors with
blanks, dashes, or #N/A
placeholders.