How do I edit a drop-down list in Excel 2020?
Drop down lists are very useful in Excel. In case you want to learn how to edit a drop down list on Excel, this post has got you covered. We will cover both the ways in which you can do it, for the longer lists and the shorter lists. Lets get started.
How to Edit Longer Drop-Down List in Excel
- Click on the cell that contains the drop-down list you want to edit its the cell with the list of months.
- Next, click on the Data tab. In the section Data Tools, go to Data Validation.
- In the pop-up window that appeared, go to the tab Settings and click into the box Source.
- Excel will take you to the location of the source cells for this drop-down list. In this case, its the sheet Months. The list in the image is made up of options that are contained within cells A1 and A12.
- In case you want to edit the drop-down menu, you will need to get rid of the information in the Source box. Highlight it and press Delete.
- After this, select the months that you want.
- Double-check whether everything is correct and confirm with OK.
These steps can be used for editing the list in the way you want. The drop-down menu will display only the items present in the cells you included as the source.
How to Edit Shorter Drop-Down List in Excel
Now that we have covered the longer drop down lists, lets take a look at the shorter list that usually only consist of Yes and No options. In some cases, a third Maybe can also be added.
The first few steps are the same as the ones used for editing longer drop-down lists.
- Click on the cell with the drop-down list, go to Data, then Data Validation. As you can see, the source here is not a range of cells, but specific text, so its alright if you just type in Maybe at the end of the line and dont forget to separate it with a comma.
- Once you add the option, just click Ok and thats all you need to do. Your shorter drop down list will be edited.
So those were the steps with which you can easily edit drop down lists in Excel. Hopefully, after reading this post, you will be able to do this with ease on your Excel spreadsheets.