Prev: Returning multiple text data into 1 column from many column entrie
Next: What's this: [Sales] ?
From: lee-sc on 4 Mar 2010 01:53
Hi

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

Thanks in advanced

From: Ant on 4 Mar 2010 07:46
What version of Excel are you using?

"lee-sc" wrote:

> Hi
>
> Could you please share with me how to create drop down list in Excel 2007?
>
> Thanks in advanced
>
From: Ant on 4 Mar 2010 07:56
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

"lee-sc" wrote:

> Hi
>
> Could you please share with me how to create drop down list in Excel 2007?
>
> Thanks in advanced
>
 | 
Pages: 1
Prev: Returning multiple text data into 1 column from many column entrie
Next: What's this: [Sales] ?