Find Invalid Data when Using Data Validation March 4, 2012Posted by computertrainer in Excel Tips, Office 2003 Tips, Office 2007 Tips, Office 2010 Tips.
Tags: circle invalid data, data validation, Excel, invalid data
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.
- Tools Menu
- Formula Auditing
- Show Formula Auditing Toolbar
- From the Formula Auditing Toolbar, click the Circle Invalid Data icon
- To remove the circled cells, click the Remove Invalid Data icon to the right of the Circle Invalid Data icon.