To clear the circles : Validation « Data Analysis « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Data Analysis
  3. Validation
Click the Data Validation button arrow, and then click Clear Validation Circles.
Click the Data Validation button arrow, and then click Clear Validation Circles.
10.5.Validation
10.5.1.Create Validation RulesCreate Validation Rules
10.5.2.View invalid dataView invalid data
10.5.3.To clear the circlesTo clear the circles