Microsoft KB Archive/288972

= How to suppress the printing of errors in workbook cells in Excel 2002, Excel 2003 and Excel 2007 =

Article ID: 288972

Article Last Modified on 2/5/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q288972





SUMMARY
This step-by-step article describes how to suppress the printing of cell errors in a workbook in Microsoft Excel 2002, in Microsoft Office Excel 2003, and in Microsoft Office Excel 2007.

How to suppress the printing of errors
Excel provides a way to suppress the printing of errors in cells or to change the format in which they are printed. To do this, follow these steps:
 * 1) Start Excel, and then open the workbook that you want.
 * 2) On the File menu, click Page Setup.

NoteIn Excel 2007, click Page Setup on the Page Layout tab.
 * 1) In the Page Setup dialog box, click the Sheet tab.
 * 2) In the Cell errors as list (in the Print area of the Sheet tab), do one of the following:
 * 3) * Click   if you do not want cell errors to be printed.
 * 4) * Click -- if you want cell errors printed as dashes.
 * 5) * Click #N/A if you want cells that contain errors to be printed with #N/A in the cell.
 * 6) * Click displayed if you want to print cell errors.
 * 7) Click OK.

Additional query words: OfficeKBHowTo inf XL2002 XL2003 XL 2007 kbnoOfficeAlertID

Keywords: kbhowtomaster KB288972

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.