Drop down menu
 

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

Drop down menu
 

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

Drop down menu
 

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

Drop down menu
 

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

Drop down menu
 

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

Drop down menu
 

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

Drop down menu
 

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
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

Drop down menu
 

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

Drop down menu
 

See post #6


--
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

Drop down menu
 

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