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

    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.


  2. #2
    Join Date
    Oct 2003
    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:


    Now the dropdown should have a blank at the top.

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

    (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