Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel

Posted on 2012-03-20
3
Medium Priority
?
337 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:Gašper Kamenšek
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:
Gašper Kamenšek earned 2000 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

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.

Question has a verified solution.

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

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

916 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