How to Create and Edit Drop-down List in Excel
Excel provides a nice way of creating drop-down lists (called combo boxes in Access). These lists come with several options to control what we want to allow in the cells/columns. Let’s have a look at the process to help us to create and edit drop-down list in Excel.
Let’s use the following Excel sheet that shows 3 tasks and the initials of the owners of these tasks.
First select the whole column by clicking on the column heading i.e. F in this case.
Now go to Data tab. Make sure that Data Validation button is open and then click on Data Validation.
The following screen will show.
Select List from the above drop-down box and then enter the three values that are already there on the spread sheet as shown below. Also make sure that Ignore blank and In-cell dropdown options are checked. Now click on OK to close this box.
Now note that when you click on any of the cell under within Column F, you’ll see an arrowhead that you can click and select the any of the values that were just entered in the previous screen.
Now let’s try to enter a value under the Owner Column which is not on the list of values that we have created. If we create a new task and enter, let’s say AS in the Owner column, we’ll get an error message.
Going back to the Data Validation Options screen, there are many other ways of controlling an validating data that you can find useful.
Just try different options and see which one is more appropriate to what you want to achieve.