Drop down menu-How do you produce a drop down menu in a single cell in Excel

How do you produce a drop down menu in a single cell in Excel

Hi Freddo,

If I understand what you are looking for, DATA | VALIDATION | LIST

hth
regards form Brazil
Marcelo

"Freddo" escreveu:

> How do you produce a drop down menu in a single cell in Excel

I think I am doing it wrong, what do you type for the source to get the list
from another spread sheet. I have typed in the source and I am just getting
the formula in the drop down menu and not a list

"Marcelo" wrote:

> Hi Freddo,
>
> If I understand what you are looking for, DATA | VALIDATION | LIST
>
> hth
> regards form Brazil
> Marcelo
>
> "Freddo" escreveu:
>
> > How do you produce a drop down menu in a single cell in Excel

Name the range of the list of data first, then type in the source =name.

I have worked out how you can make a list but I have only worked out if the
list is on the same spreadsheet can you put the list on another spreadsheet

"Marcelo" wrote:

> Hi Freddo,
>
> If I understand what you are looking for, DATA | VALIDATION | LIST
>
> hth
> regards form Brazil
> Marcelo
>
> "Freddo" escreveu:
>
> > How do you produce a drop down menu in a single cell in Excel

Highlight your list, type a name for it in the white box on the top left of the screen that usually shows the cell name.
Then do Data Validation-List and type in source =name of range

Freddo

You use the generic term "spreadsheet".

Do you mean worksheet in a workbook or another workbook?

To use a list from another worksheet or workbook, you must give the list a name
and use the name in the source dialog box.

See Debra Dalgleish's site for how to do this.

http://www.contextures.on.ca/xlDataVal05.html


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 07:19:01 -0700, Freddo <Freddo@discussions.microsoft.com>
wrote:

>I think I am doing it wrong, what do you type for the source to get the list
>from another spread sheet. I have typed in the source and I am just getting
>the formula in the drop down menu and not a list
>
>"Marcelo" wrote:
>
>> Hi Freddo,
>>
>> If I understand what you are looking for, DATA | VALIDATION | LIST
>>
>> hth
>> regards form Brazil
>> Marcelo
>>
>> "Freddo" escreveu:
>>
>> > How do you produce a drop down menu in a single cell in Excel

How do you name the range

"matt_the_brum" wrote:

>
> Name the range of the list of data first, then type in the source =name.
>
>
> --
> matt_the_brum
> ------------------------------------------------------------------------
> matt_the_brum's Profile: http://www.excelforum.com/member.php...fo&userid=5751
> View this thread: http://www.excelforum.com/showthread...hreadid=567879
>
>

See post #6

Iam sorry I seem to have done it wrong it does not seem recongnise the naming
of the range

"matt_the_brum" wrote:

>
> Highlight your list, type a name for it in the white box on the top left
> of the screen that usually shows the cell name.
> Then do Data Validation-List and type in source =name of range
>
>
> --
> matt_the_brum
> ------------------------------------------------------------------------
> matt_the_brum's Profile: http://www.excelforum.com/member.php...fo&userid=5751
> View this thread: http://www.excelforum.com/showthread...hreadid=567879
>
>