Solved

Excel

Posted on 2012-03-20
3
320 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Scale shapes without distorting 20 75
Highlighting in OneNote Windows 10 10 172
Increase Userform view size in Excel VBA 8 40
Searching good PDF to OCR 7 33
Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

911 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

15 Experts available now in Live!

Get 1:1 Help Now