Solved

Create dropdown list in excel 2007

Posted on 2007-12-03
2
3,710 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
My experience with Windows 10 over a one year period and suggestions for smooth operation
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

831 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