• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • Last Modified:

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
0
TonyBarnes
Asked:
TonyBarnes
  • 2
1 Solution
 
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
 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now