Drop Down lists in excel

[Daesy]

Hi Guys, This is my first post so hopefully I am putting it in the right place!

I am trying to create a drop down list in excel (this is something I do all the time on my work PC, but am having trouble on my own mac)

I create and name the list using Insert - Name - Define

Then I click in the cell that I want the drop down in, Data - validation - Allow:list - enter the name of the list into data source

It does create a drop down option, however the only thing in the list is the name of the list! Its very frustrating

can anyone tell me where I am going wrong?

If it makes a difference, I am using a macbook4,1 and excel 2004 version 11.6


Is there an excel guide book that I can read online to answer my query?

Thanks!

 

[GGJstudios]

Why don't you try the Excel Help function? There are detailed instructions there under "Restrict Data Entry". Also, if you use Google, I'm sure you'll find some Excel forums and support sites.

 

[Gregg2]

I'm sure you'll find some Excel forums and support sites.

like http://www.mrexcel.com/forum/forumdisplay.php?f=10&order=desc

 

[Daesy]

Thanks guys, ill give it a go