Business Insider Edition
Drop-down lists are very helpful tools in Microsoft Excel , especially for creating forms or providing guidelines for other users.
There are many different ways to create a drop-down list , and accordingly, there are also different methods you might need to use to edit those lists if you want to make changes.
If your list is based on an Excel table, then this process is incredibly simple just add or delete the items from the table, and Excel will update the drop-down list for you automatically.
However, if your drop-down list is based on a range of cells, a 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.
1. Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired item.
2. Select the cell that contains the drop-down list, then, in the Data menu at the top of your screen, click Data Validation, and select Data Validation again from the menu.
3. In the Settings tab of the pop-up menu, under Source, adjust the cell range to include the new cell you entered data into, or to exclude the one you deleted it from. Then click OK to save your changes.
1. 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 that your drop-down list is based on, and edit the "References" formula to either include the cell you just added, or to exclude the one you deleted. Then click "Close" to save your changes, and "Yes" to confirm.
1. Under the Data tab, click on Data Validation.
2. In the settings tab of the pop-up window, under Source, add or delete list items as necessary, making sure all items are separated with a comma and nothing else. Then click OK to save your changes.
NOW WATCH: 8 weird robots NASA wants to send to space
See Also:
SEE ALSO: The best Macbooks you can buy
