Solved

What is the simple method of making drop-down lists in Excel

Posted on 2014-10-01
3
185 Views
Last Modified: 2014-10-03
We have an Excel spreadsheet.  We want to add several drop-downs for the fill-in areas, if possible.  Is there a simple way to make drop-downs in Excel?

We will appreciate any assistance that you can give.

Thank you.

sherman6789
0
Comment
Question by:sherman6789
3 Comments
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 250 total points
ID: 40355883
0
 
LVL 41

Accepted Solution

by:
pcelba earned 250 total points
ID: 40355923
This seems to be easier to understand: http://office.microsoft.com/en-001/excel-help/create-a-drop-down-list-HA102809802.aspx

Good luck!

BTW, even when you define Drop down combos in your cells it is still possible to write any value into the cell e.g. by OLE Automation.
0
 

Author Closing Comment

by:sherman6789
ID: 40360192
The information contained in both answers were great.  The example from "pcelba" is simpler and easier to understand. however, the additional information in Rey Obrero answer give more variety and understanding about how the system works.
Thanks to both of you.

-sherman6789
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

809 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