How to Quickly Add Items in Drop-Down List
Follow these steps to quickly add new items to a drop-down list-
Note that for the sake of this example, we are taking a drop-down based on a cell range containing names as shown below-
Step 1: Right-click on the Cell and Select Insert a new cell in the cell range
To insert a new cell in the cell range, click on the cell below the position where you want to insert the cell. Right-click the cell and click on Insert.
This will open a dialog box.
Step 2: Select the Shift cells down from the options and Click ok
In the dialog box that opens, select the shift cells down option and click ok.
This will create a new empty cell just below the first item.
Step 3: Add the new item
In the new cell just created, simply type the item you want to add.
You will see that the new item is added to the drop-down list automatically.
To add more items, simply repeat the above three steps.
How to Edit, Copy and Delete Drop Down List in Excel
A drop-down list allows us to make our Excel sheet more dynamic and intelligent by allowing the users to choose from a list of predefined options. Not only does this make data entry fast but it also helps in restricting the data that can be added to some cells.
Naturally, once you have created a drop-down list, you might also need to edit, copy, or delete it at some point in time. And this is exactly what we are going to learn about in this article. So let us look at the different ways in which you can edit, copy, and delete a drop-down list in Excel but first, check out how to create a dropdown in Excel if you don’t already know.
Contact Us