Excel

In excel how do i create a 'drop down' box from a cell from which I can select an option from the box which becomes the entry in the cell?

i.e. cell A1 is 'Contractors', when you click on the cell a box opens with a list of contractors which i then scroll down and select one of them, that name then appears in the cell.

Thanks
TonyBarnesAsked:
Who is Participating?
 
Gašper KamenšekExcel MVPCommented:
Hi,

You can do this by giving the Range in which your entries reside a name. You mark it, and then in the name box give them  a name like LIST.

Then in the Data Validation window you say list and for the source write =LIST, and that is it.

Good luck
0
 
Gašper KamenšekExcel MVPCommented:
Hi, this can be done by Data Validation,

you stand on the cell where you want the dropdown and then go to Data/Data Validation.
You choose List and then either enter the Names and separate them by commas or you just give reference to a group of cells where the names reside (e.g. A1:A10)

Have a nice day and good luck
0
 
TonyBarnesAuthor Commented:
How do you reference a group of cells, the list i am putting in has 58 entries and is on a separate Sheet in the file, so what is the command string to access/show that please?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.