Drop down menu

M

Marcelo

Hi Freddo,

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

hth
regards form Brazil
Marcelo

"Freddo" escreveu:
 
F

Freddo

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
 
F

Freddo

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
 
M

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
 
G

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
 
F

Freddo

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