Thread: Drop Down Menu
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Workbook Workbook is offline
external usenet poster
 
Posts: 121
Default Drop Down Menu

In cell A2 I want to put a drop down menu/box. In other words I want to be
able to click on a downward arrow in cell A2 and then have the ability to
select from five different options such as I-Phone, Desktop Computer, Laptop
Computer, Touch Screen Monitor, and Wireless Internet Connection.

If I select any one of these options, (such as Touch Screen Monitor) that
selection will appear in cell A2. I guess, I am wondering, is it possible to
create a drop down menu in a single cell and if so can you tell me how?