Solved

how do you do a drop down menu and a radio button in Excel 2010

Posted on 2013-02-05
1
653 Views
Last Modified: 2013-02-05
I need to know how you do a drop down menu with different selection in a cell in Excel 2010 and also how do you insert a radio button?
0
Comment
Question by:kwhittemore
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 13

Accepted Solution

by:
Shanan212 earned 500 total points
ID: 38855160
Easiest way to do drop down is data validation

Go to Data tab
Click Data Validation
On Settings Tab, under the 'Allow' drop down, select 'List'
On Source box, either type in your selections

Eg:

Yes, No

or choose the cells where your lists are on.

For radio buttons: This links explains it better

http://www.extendoffice.com/documents/excel/914-excel-insert-radio-button.html
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

707 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