jump to navigation

Find Invalid Data when Using Data Validation March 4, 2012

Posted by computertrainer in Excel Tips, Office 2003 Tips, Office 2007 Tips, Office 2010 Tips.
Tags: , , ,
trackback

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

Comments»

No comments yet — be the first.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 70 other followers

%d bloggers like this: