Solved

Excel

Posted on 2012-03-20
3
317 Views
Last Modified: 2012-03-21
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
Comment
Question by:TonyBarnes
  • 2
3 Comments
 
LVL 10

Expert Comment

by:GasperK
ID: 37742641
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
 

Author Comment

by:TonyBarnes
ID: 37746158
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
 
LVL 10

Accepted Solution

by:
GasperK earned 500 total points
ID: 37746181
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now