How to create a droplist in a cell? Thank you in advance for your help...MK
A abcd Jun 23, 2005 #2 Menu Data > in Validatation options you must choose to permit only a "list" of values... the list may be in cells A1:A10 for example or may be given as is 1;2;3
Menu Data > in Validatation options you must choose to permit only a "list" of values... the list may be in cells A1:A10 for example or may be given as is 1;2;3
A Anne Troy Jun 23, 2005 #3 Here's a pretty descriptive article, MK. http://www.officearticles.com/excel/drop-down_using_data_validation_in_microsoft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com
Here's a pretty descriptive article, MK. http://www.officearticles.com/excel/drop-down_using_data_validation_in_microsoft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com
