Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Filtering Columns for Unique Values
Printing Multiple Worksheets on a Single Page
Suppose you have a worksheet in which there is an error (such as #VALUE! or #DIV/0! or #NUM! or any number of other errors), but you are not quite sure what caused it. As you may know, this is not that odd of an occurrence. It is possible (and sometimes common) to have a single error propagated throughout an entire worksheet. If you don't know where the error is coming from, the easiest way to find out is to follow these steps:
Excel tracks down the source of the error, using red auditing arrows. You can now make your corrections and get rid of at least one error in your workbook.
Excel 2002 and Excel 2003 have another handy way you can track down errors. If a cell contains an error value, the upper-left corner of the cell will have a small green triangle in it. If you select the cell, and information tool tip appears near this green triangle. When you click on the tool tip you see a menu that includes several different helpful suggestions, including an option to Trace Error. If you choose this option, you get the same result as if you followed the steps outlined above.
You should note that you can use the Trace Error auditing tool only to track down the source of obvious error conditions, meaning those that display an error condition such as #NA or #NAME. Subtle errors, such as adding together the wrong values or using the wrong function, cannot be detected by Excel and must be tracked down manually.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3091) applies to Microsoft Excel versions: 97 2000 2002 2003
Make Home Buying Less Stressful! Why make home buying harder than it needs to be? Put your mind at ease—discover all the questions you need to ask to make the best buying decision.