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.
  3. Data Validation list

    Select Circle Invalid Data. A red circle appears around all invalid data on the worksheet.

    Invalid data circled

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.

Follow us on

Facebook  Twitter  You Tube