• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 26. Error-Proof Data-Entry Techniques > Troubleshooting Data Errors

Troubleshooting Data Errors

When you audit a worksheet, Excel finds cells that contain values that are outside the limits you define with data validation rules. This technique is the only way to find incorrect values that a user pasted using the Clipboard, or invalid values that are the result of a formula.

These auditing tools are not available from any menu. The only way to identify invalid data is to click a button on the Auditing toolbar; curiously, this option never appears on the list of toolbars that Excel displays when you right-click an existing toolbar. To display the Auditing toolbar, choose Tools, Auditing, Show Auditing Toolbar.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint