.svg){kind=icon}
.gif)
.svg)
It is very easy to edit the drop-down list source in Microsoft Excel. Here’s a quick guide on how to do it:
- Inside your Microsoft Excel worksheet, find and select the cell containing the drop-down list you wish to edit.
- After that, navigate to the top menu bar and then click 'Data'.
- Select 'Data Validation' from the available options.
- Next, click the "Source' input field and make your desired changes. You can reselect the cell range you wish to use or type the cell reference manually.
- Once done, click 'Apply' to proceed.
- After completing these steps, the source of the selected drop-down list will be updated based on your input.
