Set up reliable data validation in Excel
Friday, September 12th, 2008You can use data validation to restrict the type of information allowed in a given cell (or cells). In addition, you can use data validation to limit data to a predefined list of acceptable items and display the items as an in-cell dropdown list.