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
- Page Setup
- Sheet
- In print area- cell errors as- select how you want to print or suppress your errors
For earlier versions of Excel
- File > Page Setup
- Go to the Sheet tab
- 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.