Solved

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

Posted on 2013-05-09
3
560 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
Comment Utility
0
 
LVL 80

Accepted Solution

by:
byundt earned 500 total points
Comment Utility
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
Comment Utility
Thanks
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all theā€¦
Outlook Free & Paid Tools
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

728 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

13 Experts available now in Live!

Get 1:1 Help Now