Drop down menu

[Guest]

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

 

[Guest]

Hi Freddo,

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

hth
regards form Brazil
Marcelo

"Freddo" escreveu:

 

[Guest]

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

 

[Guest]

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

 

[matt_the_brum]

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

 

[matt_the_brum]

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

 

[Gord Dibben]

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

 

[Guest]

How do you name the range

 

[matt_the_brum]

See post #6

 

[Guest]

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