Adding a Dropdown list in an EXCEL spreadsheet

[Neozero]

How do I go about adding a drowndown list in a current spreadsheet to give a user options to choose from ?

 

[Zathras]

There are a couple of ways. The simplest would be to use Data / Validation... Allow: List and type in a comma-separated list of the options you want to offer.

Without knowing more about what you are really trying to do, it is hard to be more specific.

 

[RamziSaab]

if you choose the row where u want the drop down list and go to data filter autofilter it will make a drop down list for you ...

dont know if that is what u are looking for