Validate a worksheet
Tools such as Autofill are not recognised by Data Validation, meaning invalid data can be entered onto a worksheet. Invalid entries on a worksheet can be highlighted using the Circle Invalid Data tool.
Highlight invalid data
- Click the Data tab on the Ribbon
- Click the list arrow on the Data Validation button in the Data Tools group.
Select Circle Invalid Data. A red circle appears around all invalid data on the worksheet.
Remove invalid data highlights
To remove the circles from cells containing invalid data:
- Correct the data in the cell and the circle will disappear
- Click the list arrow on the Data Validation button and select Clear Validation Circles
Clearing the circles will remove the circles but the data remains unchanged and therefore invalid.