Excel Hiding Errors on Printouts

Excel error values show up with a hash symbol followed by the type of error, e.g. #DIV/0! or #N/A.

When printing, these errors print by default, however you can choose to have Excel not print the error values.

Display the Page Setup (dialogue box).  From the Sheet (tab), use the Cell Errors As (drop down box) to specify how error values print.

  • displayed – prints the error values as they show in the worksheet.
  • <blank> – replaces the error value with a blank; effectively hiding error values.
  • – – replaces the error value with two dashes.
  • #N/A – replaces all error values with #N/A.

 

Excel Hiding Errors on Printouts

Invercargill

64 Arena Avenue, Unit 5

Phone: 03 214 2323

Dunedin

Level 3 Queens Building 109 Princes Street

Phone: 03 474 9943

Locations

New Plymouth
Wellington
Christchurch