Dropdown List For Individual Cell

[Heath]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Will Excel create a dropdown list for cells within a column, restricting the options a user has for that cell.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Will Excel create a dropdown list for cells within a column, restricting the
options a user has for that cell.

Use Data/Validation. See the "Restrict data entry" topic in XL Help, or

http://www.contextures.com/xlDataVal01.html

for more.