Solved

Create dropdown list in excel 2007

Posted on 2007-12-03
2
3,708 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
Comment Utility
0
 
LVL 70

Assisted Solution

by:KCTS
KCTS earned 200 total points
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
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 Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
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…

772 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

15 Experts available now in Live!

Get 1:1 Help Now