It helps guide a user to manually enter values in a cell with some specific values to choose from. I have already explained above why we need drop-down lists in our data. The above process has solved our problem where if a new entry has to be created and dropdowns needed to be made all over again.Įxplanation of Edit Drop-Down List in Excel