+ Reply to Thread
Results 1 to 3 of 3

How to edit a drop down list?

  1. #1
    Registered User
    Join Date
    05-20-2009
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question How to edit a drop down list?

    Hi there everyone, I normally enjoy being presented with Microsoft Office puzzles from co-workers and can normally find the answers online, but I'm finally stumped. How do you edit a drop down list in Excel? This is a spreadsheet created by a former employee.

    The drop down list is very simple, it offers a short list of initials of staff members in charge of various tasks. On the header, if you click the drop down tool you can sort the list by the staff members.

    They are trying to remove the initials of the one of the former employees from appearing in the drop down list.

    I have already tried the Data/Validation route but it looks like the person who created the list did not use this method to create the drop down list. I also tried Insert/Name/Define and it does show the drop down list under "names in workbook", and appears to reference a source in "Refers to", but I still cannot figure out how to edit the darn list.

    Any help or suggestions would be greatly appreciated. Thank you

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: How to edit a drop down list?

    Hello IPreferWord,

    You're either looking at a Filtered table, or a drop-down list (combobox) created using ActiveX or Forms controls. (View -> Toolbars -> Controls Toolbox or View -> Toolbars -> Forms)

    If it's a filtered table of data (Data -> Filter -> Autofilter), you cannot remove entries from that list. You would need to delete any occurrences of that entry from your table of data.

    If it's a combobox, and it's from the Forms toolbar, you should be able to right-click on it and select Format Control, then review it's Input Range to see where the list resides. If it's from the Controls Toolbox toolbar, click the 'Design Mode' button on that toolbar, then right-click on the combobox and choose Properties, then look at the ListFillRange property to see where it's getting it's source of drop down options.

    If that doesn't help, try posting the sheet and we can come up with a resolution, I'm sure.

  3. #3
    Registered User
    Join Date
    05-20-2009
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    2

    Red face Re: How to edit a drop down list?

    Hi and thanks for the reply! Really appreciate it. I'm attaching the sheet. I think it may be an autofilter, because when I go to Data/Filter the AutoFilter option is checkmarked, but I don't know which column its referring to (or really, how that feature works at all). I had no idea how little I knew about Excel until I ran into this.
    Attached Files Attached Files

+ 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