Display or hide circles around invalid data
Circle invalid cells
All cells that don't meet their data validation criteria are circled, including values that were typed, copied, or filled in the cells, calculated by formulas, or entered by macros.
- Point to Formula Auditing on the Tools menu, and then click Show Auditing Toolbar.
- Click Circle Invalid Data
.
Hide validation circles
- To remove the circle from a single cell, enter valid data in the cell.
- To hide all circles, point to Formula Auditing on the Tools menu, make sure the Show Auditing Toolbar command is checked, and then click Clear Validation Circles
.