Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    9

    Unanswered: Excel: drop-down list with edit capability

    Hi there, I can create a drop-down list in excel no problem, but how do you create a list whereby if there is no selection which would apply to you, you could have a blank where you enter your own selection/choice.

    Regards,
    trevanw

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    If you are using Validation, then define your list by name (i.e. myList), but be sure that the top cell is blank, except now type a single quote ' in that cell. Then in Validation, choose List, and in Source, type:

    =myList

    Now the dropdown should have a blank at the top.

    HTH
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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