Microsoft Office Tutorials and References
In Depth Information
Figure 19-27: Excel can draw circles around invalid entries (in this case, cells that contain values greater
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.