Create dropdown list in excel 2007

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
LVL 11
bsharathAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
KCTSConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.