Chapter-10: Circle Invalid Data

We can encircle the invalid values in the excel cells.

For example in an excel sheet we have some numbers as given in the below image. Now we put the Whole Number Validation to enter the numbers less than or equal to 50.

 

Whole Number Validation
Whole Number Validation

 

After putting this validation we will not be able to enter numbers which are greater than 50, but few numbers which are greater than 50 are already available in sheet before putting the validation. Now those numbers are invalid values as per the validation.

 

Invalid value entry error message
Invalid value entry error message

We can circle such invalid values.

  • Select the range.
  • Goto to Data Tab>>Data Validation>>Click on Circle Invalid Data
Circle Invalid Data option
Circle Invalid Data option

Invalid values will be circled.

 

Circled Invalid values
Circled Invalid values

 

Clear Validation Circles:

  • Go to to Data Tab>>Data Validation>>Click on Clear Validation Circles
Clear Validation Circles
Clear Validation Circles

 

Previous Chapter