Page 133 - Excel 2013 All-in-One For Dummies

Data Entry 101 115
Figure 1-15:
Getting
an error message after trying to input a city that’s not on the list.
To find cells to which Data Validation has been applied, open the Go To dialog box (Ctrl+G or F5), and then click the Special button and click the Data Validation option button in the Go To Special dialog box. Click the Same option button under Data Validation to have Excel go to the next cell that uses the same Data Validation settings as the active cell. Leave the All option button under Data Validation selected to go to the next cell that uses any kind of Data Validation setting.
To get rid of Data Validation settings assigned to a particular cell or cell range, select the cell or range, open the Data Validation dialog box (Alt+AVV), and then click the Clear All button before you click OK.
Although Data Validation is most often used to restrict new data entries in
a spreadsheet, you can also use it to quickly identify values that are outside desired parameters in ranges of existing numeric data entries — see Book II, Chapter 3 for details.
Book II Chapter 1
Building Worksheets