Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

View products that this article applies to.

This article was previously published under Q288972

↑ Back to the top


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.
  3. In the Page Setup dialog box, click the Sheet tab.
  4. In the Cell errors as list (in the Print area of the Sheet tab), do one of the following:
    • Click <blank> if you do not want cell errors to be printed.
    • Click -- if you want cell errors printed as dashes.
    • Click #N/A if you want cells that contain errors to be printed with #N/A in the cell.
    • Click displayed if you want to print cell errors.
  5. Click OK.

↑ Back to the top

Keywords: KB288972, kbhowtomaster

↑ Back to the top

Article Info
Article ID : 288972
Revision : 4
Created on : 2/5/2007
Published on : 2/5/2007
Exists online : False
Views : 331