![]() |
|||
![]() |
|||
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 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)
|
|||
![]() ![]() ![]() ![]() ![]() |
|||
Copyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved. |