View invalid data : 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 Circle Invalid Data
Click the Data Validation button arrow, and then click Circle Invalid Data
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