Excel > Excel 2007 Advanced > Auditing Worksheets

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

1. Click the Data tab on the Ribbon
2. 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

Or

• 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.

Data Validation Tracing formulas

Guides