Unformatted text preview: * For "Allow" choose "List". For "Source" indicate your list range, including the blank cell. * Click OK. * Copy this cell down the column so the cells beneath it have the same characteristic. * Try it out. Whenever you click in a "Category" column cell, the drop down should appear to allow the user to make a selection from the list without typing. Benefits Easier for the user and no chance of user error. * From Excel's menus, choose Tools, Data Validation to open the "Data Validation" dialog....
View Full Document
- Spring '01
- data validation, DropDown Selection, DropDown Selection Box, possible user errors.