Drop Down lists in excel

Discussion in 'Mac Apps and Mac App Store' started by Daesy, Oct 22, 2010.

  1. Daesy macrumors newbie

    Oct 22, 2010
    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?

  2. GGJstudios macrumors Westmere


    May 16, 2008
    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.
  3. Gregg2 macrumors 603

    May 22, 2008
    Milwaukee, WI
  4. Daesy thread starter macrumors newbie

    Oct 22, 2010

Share This Page