In this tutorial, we will learn how to create a dropdown list in Excel for Mac 2011. This is useful if you have a list of items that you input frequently and would like to choose from a dropdown list instead of the standard method of typing in the data.
For our example, we will be keeping a spreadsheet of statistics for a sports team and we need a dropdown list for the result of games. Our options are Win, loss or Tie. I will show you two methods of creating the list.
Here is our spreadsheet:
In column D, we want to be able to choose Win, Loss or Tie from a dropdown list. Let’s create the list. What we will do is select some cells in column D. Let’s go down as far as D10.
Now we will go to our Ribbon and click on Data, then click on Validate. The data validation window will now appear.
Under the validation criteria area we will click on the dropdown list under the heading Allow and we will choose List.
The Source box now becomes available. In this box we will type our list options separated by a comma. Then we will click OK.
Let’s fill in some data in the first row. We will say that our team won this game 4-1. When we get to the result column, we’ll click on the dropdown arrow in the cell then select Win as our result.
The other way we can create a dropdown list is to create the list from an already existing list in the spreadsheet. Let’s enter our Win, Loss and Tie options into cells, then highlight the cells that you want to apply the data validation to as we did in the first example.
Now go to Data on the ribbon then click Validate just was we did in the first example. We will again choose List from the Allow box under Validation Criteria heading. This time however, we will click on the little button to the right of the Source box.
This will minimize the Data Validation window. Next, we will highlight the data that we want to use for our list. You will see the cell reference appear in the source box.
Click on the small button to the right of the source box to maximize the data validation window, click the OK button and your list has been created.