Microsoft Office Tutorials and References
In Depth Information
Data Validation
Figure 19-27: Excel can draw circles around invalid entries (in this case, cells that contain values greater
than 100).
Creating a drop-down list
Perhaps one of the most common uses of data validation is to create a drop-down list in a cell.
Figure 19-28 shows an example that uses the month names in A1:A12 as the list source.
Figure 19-28: This drop-down list was created using data validation.
 
Search JabSto ::




Custom Search