how do I add Drop down menues in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up Drop Down Menues as part of an Excel Workbook. Can
anyone help explain how this is done?
 
Hi Madjock,

Select the area where you want the drop down. Then click Tools > Data
Vaildation. Use the dropdown menu to select Custom. Type in your list
using a comma as a seperator e.g

Dog,Cat,Mouse

If you have a list then the below link should help

http://www.contextures.com/xlDataVal01.html

VBA Noob
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatted cell column in drop down list 1
Date Range Drop Down Menu 1
Vlookups not working 2
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
How do I change fonts in a DV drop down menu 1
Excel 2007 / right-click / pick from drop down list 1
DROP DOWN MENU "source" 5
Functions / Drop Downs won't calculate 1

Back
Top