This preview shows page 1. Sign up to view the full content.
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
This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.
- Spring '01