- You can edit a dropdown list in Excel using a few different methods.
- It’s easy to edit a drop-down list if it’s based on an Excel table, since the table should automatically update with your edits.
- If you want to edit a drop-down list based on a cell range, named range, or manual input, the process will require a few more steps.
- Visit the Business Insider home page for more stories.
Drop-down lists are very useful tools in Microsoft Excel, especially for creating forms or providing guidelines for other users.
There are many different ways to create a dropdown list, and consequently there are also different methods you may need to use to edit those lists if you want to make changes.
If your list is based in an Excel table, then this process is incredibly simple: just add or remove items from the table and Excel will update the dropdown list automatically.
However, if your drop-down list is based on a cell range, named range, or was entered manually, the process requires a few extra steps.
Here’s how to edit a drop-down list in Excel in each case, using the software on your PC or Mac computer.
Check out the products mentioned in this article:
MacBook Pro (Starting at $1,299.99 at Best Buy)
Lenovo IdeaPad 130 (Starting at $299.99 at Best Buy)
How to edit a drop-down list in Excel based on a range of cells
1. Go to the worksheet or area of your current worksheet where your list items are located, and then add or remove the desired item .
2. Select the cell that contains the dropdown menu. bottom, then on the Data menu at the top of the screen, click Data Validation and select Data Validation again from the menu.
3. On the Settings tab of the pop-up menu, under Font, adjust the cell range to include the new cell in which you entered data, or to exclude the one who removed it. Then click OK to save the changes.
How to edit a dropdown list in Excel based on a named range
1. Add add a new item to your list or delete the one you don’t want.
2. Go to the Formulas tab, then select Name Manager.
3. Select the named range your dropdown list is based on and edit the “References” formula to include the cell you just added, or to exclude the one you deleted. Then click “Close” to save the changes and “Yes” to confirm.
How to edit a drop-down list in Excel that was entered manually
1. Under the Data tab, click Click Data Validation.
2. In the settings tab of the pop-up, under Source, add or remove items from the list as needed, making sure that all items are separated by a comma and nothing else. Then click OK to save your changes.
Related Coverage of How To Do Everything: Technology:
-
Deleting Duplicates in Microsoft Excel to Clean Data in Single or Multiple Columns
-
How to Create a Drop Down List in Excel to Manage Data and Avoid Mistakes
-
How to move columns in Microsoft Excel to organize your spreadsheet data
-
How to hide and show rows in Microsoft Excel in 2 different ways
-
How to remove blank rows in Microsoft Excel to sort your spreadsheet
.