Part IV: Managing and Analyzing Data
Excel makes it easy to specify the validation criteria. You can also use a formula for more
complex criteria.The Excel data validation feature suffers from a potentially serious problem: if the user copies a cell that does not
use data validation and pastes it into a cell that does use data validation, the data validation rules are deleted. In
other words, the cell then accepts any type of data. This has always been a problem, and Microsoft still hasn’t fixed it
in Excel 2019.Specifying Validation Criteria
To specify the type of data allowable in a cell or range, follow these steps:- Select the cell or range of cells.
- Choose Data ➪ Data Tools ➪ Data Validation. The Data Validation dialog box
appears, as shown in Figure 26.2.
FIGURE 26.2
The three tabs of the Data Validation dialog box