You can add a drop-down list in Microsoft Excel using the data validation option. This allows you to add a list of options, which can be edited at any time if you wish.
1. Select the cells or column you want to have the drop-down list.
2. Go to Data then select Data Validation.
3. Set Allow to List.
4. Enter your list, separating each item with a comma.
5. Click Ok.
How to Add a Drop-Down List to More Cells
If you have an existing drop-down list then you can quickly add it to other surrounding cells. This can be done by selecting a cell with the drop-down menu and dragging from the bottom right corner of the cell. By dragging from the corner you will be selecting other cells to add the drop-down list to. Typically, you will want to add the drop-down to the cells above or below the selected cell.
How to Edit a Drop-Down List in Excel
You can edit an existing drop-down by reopening the Data Validation window and editing the source list. You can add items to the edit of the list, or anywhere if you wish. However, you will need to ensure you separate each item with a comma. Additionally, the items in the list will appear in the order you input. This means that if you add more options to the end of the list then they will appear at the bottom of the drop-down menu.
1. Select all the cells that you want to edit.
2. Go to Data and select Data Validation.
3. Add the new items to the source box, separating each option with a comma.
Can’t Edit Drop-Down List in Excel
If you can’t edit the drop-down list then you will need to click the arrow button on the side of the source box. This will open a separate menu which allows you to edit your drop-down list easier and select the end of the list without any issues. Once the list has been edited you will need to click the cross then Ok to confirm.
