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
Bookmarks