Create drop down list in Excel 2007

  • Thread starter Thread starter lee-sc
  • Start date Start date
L

lee-sc

Hi

Could you please share with me how to create drop down list in Excel 2007?

Thanks in advanced
 
Sorry Lee-sc, hit the send button to quick in my previous post.

In the Data menu, choose "Data Valiation", then "Data Validation".

Under Settings, select "List" in he "Allow" drop down box.

In the "Source" field, type in or select the list that you want to appear in
your drop down box.

For example, you may have a list in the range C12:C25. Type that into the
Source field.

The other two tabs in Data Validation allow you to enter messages that appar
if the user makes a mistake.

Hope this helps
 
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

Drop Down Lists 2007 10
Excel 2007 / right-click / pick from drop down list 1
Creating a Drop Down List with Step by Step Instructions for 2007 2
Created invoices in Excel - not working in Drive 1
Formatted cell column in drop down list 1
AutoComplete Feature in Drop Down Lists? 7
Data Validation List Names 2
Dependent drop down dynamic range formula, off sheet. 7

Back
Top