Solved

Create dropdown list in excel 2007

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

821 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