Solved

How to add a combo box in an excel cell of a worksheet

Posted on 2013-05-09
3
644 Views
Last Modified: 2013-06-19
Hi Experts,

Please advise me how to add a Combo box in a excel cell.
for example cell in cell A2 want to set a combox which has two value to choose from 'Telephone' or 'Fax'.
Please advise me exactly what I need to do to setup the combo box in cell A2 that user can select from the combo box drop down list either 'Telephone' or Fax.

Thanks
0
Comment
Question by:alam747
3 Comments
 
LVL 23

Expert Comment

by:tailoreddigital
ID: 39154392
0
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 39154436
You may prefer the ease and appearance of a data validation dropdown. When you click on the cell, a dropdown arrow appears to the right.

On the Data menu, there is an item called Data Validation.
Data validation menu itemIf you choose it, there appears a dialog like the following:
Data validation dialog
0
 

Author Closing Comment

by:alam747
ID: 39261482
Thanks
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

829 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