Software

How do I inhibit Excel error values when printing?

You don't have to print out Excel error values, Susan Harkins shows you hot to suppress them or replace them.

Formulas and functions can return error values for a variety of reasons and those error values are you clues to problems. However, you won't always want everyone to see them. By default, Excel prints error values, but you can print a sheet without printing error values simply enough:

  1. From the File menu, choose Page Setup. In Excel 2007 and 2010, click the Page Layout tab and then click the Dialog Launcher for the Page Setup group.
  2. Click the Sheet tab.
  3. From the Cells Error As dropdown, select <blank> or one of the other available settings (see below).
  4. Click OK.

The options available (step 3) are as follows:

  • Displayed: Prints the error values as shown in the sheet.
  • <blank>: Prints a blank cell.
  • : Prints two dashes.
  • #N/A: Prints #N/A instead of the actual error value.

The sheet will still display error values on screen, but Excel won't print them.

About Susan Harkins

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks

Free Newsletters, In your Inbox