+ Reply to Thread
Results 1 to 7 of 7

Help: allow a blank as an option in a drop down list

  1. #1
    Registered User
    Join Date
    06-25-2008
    Posts
    6

    Help: allow a blank as an option in a drop down list

    I'm trying to create a drop down list with different priorities for clients to choose from (high, medium, low) but I would also like to have a blank as an option. How can I do this?
    I am using 2007 if that matters at all.

    What I've tried:
    Making a list on a seperate sheet and including a blank cell while defining the name of the list. Whenever I set up the data validation after this it deletes the blank cell and only allows the options high, medium, low.

    Any help would be appreciated!
    Thanks,
    Laura

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    try putting blank at top of list rather than end
    e.g.
    'blank'
    low
    medium
    high

  3. #3
    Registered User
    Join Date
    06-25-2008
    Posts
    6
    tried it. no luck.

  4. #4
    Registered User
    Join Date
    03-13-2006
    Posts
    23
    In you "named range" list of possible choises, be sure to include a "blank" cell

  5. #5
    Registered User
    Join Date
    06-25-2008
    Posts
    6
    I've tried that too. I've tried putting the blank in every possible spot and it always gets deleted by Excel. Is there something that I can type in the cell that Excel will format as a blank?

  6. #6
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Those options suggested work with 2003 Not sure why not with 2007

    Maybe just enter a space in the cell you want blank??
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  7. #7
    Registered User
    Join Date
    06-25-2008
    Posts
    6
    I actually tried the space thing too.
    But I just figured it out. I'm not sure how it managed to work, when I tried all the logical solutions and none of those work.
    I put a character in the extra cell I wanted blank and then defined the name and did the data validation, after that I just deleted the character and magically it stayed as a blank!
    Who would've known?!

    Thanks for everyones help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1