Avoid Printing Errors In Excel


As we have already discussed in an earlier post, it is always good practice to know exactly what is going on with your data and formulas as well as knowing what any errors mean.

There are a few ways to hide them once you understand why you are getting the errors, if they are relevant or indicate problems with your data.  Once you are happy to hide and avoid them click here to read my post on understanding and debugging Excel errors.

If you are happy for errors to be shown on your worksheet errors or would prefer to see them, you still may want to prevent them printing.  There is a quick way for Excel to prevent them showing when you print your file.

In Excel 2007

  1. Page Setup
  2. Sheet
  3. In print area- cell errors as- select how you want to print or suppress your errors

For earlier versions of Excel

  1. File > Page Setup
  2. Go to the Sheet tab
  3. Look for a drop-down box that will let you choose how to print cell errors or suppress them completely

More Posts On Formulas

1. A compilation of most commonly used formulas.

2. Calculation basics in Excel.

What do you prefer to do, hide or deal with errors?

How do you deal with your errors? Let us know.  Please feel free to comment.

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts