Solved

Create dropdown list in excel 2007

Posted on 2007-12-03
2
3,709 Views
Last Modified: 2008-02-01
Hi,

I want to create a drop down list that comes in each cell in a colum
I need to select a specific option in the cell in each cell in the colum.Is there a way i can do this.
I have a list of 20 objects that i need to have a drop down menu.So that it becomes easy to select.Is there any inbuilt option or a script that can do this (Macro).

Regards
Sharath
0
Comment
Question by:bsharath
2 Comments
 
LVL 17

Accepted Solution

by:
Shanmuga Sundaram earned 300 total points
ID: 20395679
0
 
LVL 70

Assisted Solution

by:KCTS
KCTS earned 200 total points
ID: 20395738
You can use data validation
Create a the list of things that you want to appear in the list in a cloumn somewhere - (if its on a different sheet you must name the range to use)

Select the one cell in the column where you want the drop down
select Data->Validation and select from list - specift the list (or use its name eg =MyList)

once done, delect the cell and do COPY, then highlight the other cells where you want it to appear and select Edir->Paste Special->Validation
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

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 …
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

863 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

23 Experts available now in Live!

Get 1:1 Help Now