Find Invalid Data when Using Data Validation

Often you create Data Validation rules on worksheets that have existing data.  This tip is to help you find the data that does not meet the Validation Rules you set up.

 Excel 2003:

1. Tools Menu
2. Formula Auditing
3. Show Formula Auditing Toolbar
   
4. From the Formula Auditing Toolbar, click the Circle Invalid Data icon
5. To remove the circled cells, click the Remove Invalid Data icon to the right of the Circle Invalid Data icon.

Excel 2007 & 2010:

1. Data Ribbon
2. Data Tools Group
3. Click Data Validation (text, not icon)‚
   
4. Select Circle Invalid Data
5. To remove the circled cells, click Clear Validation Circles

About these ads