Drop Down lists in excel

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

  1. Daesy macrumors newbie

    Joined:
    Oct 22, 2010
    #1
    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
    :D

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

    Thanks!
     
  2. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #2
    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

    Joined:
    May 22, 2008
    Location:
    Milwaukee, WI
    #3
  4. Daesy thread starter macrumors newbie

    Joined:
    Oct 22, 2010

Share This Page