Excel Tip of the Day

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 -- #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.

(Content provided by Element K Journals)

(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
PrintPrint CloseClose

Copyright © 2001 - 2022 MJ Technologies, LLC.  All rights reserved.