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!