Creating Dropdown List Menu in Microsoft Excel Using Data Validation

Creating Dropdown List Menu in Microsoft Excel Using Data Validation.

OK guys, now we will try to create a dropdown list menu on our worksheet cell using Data Validation tool. Here I am using Microsoft Excel 2007 with compatibility reasons because many users that still using Microsoft Excel 2007 but still compatible if we use a newer Excel. Whereas if I use Excel 2013, I am not sure for the compatibility of Excel 2007. the dropdown list menu is very useful when we handle a lot of data, but if the data has a fixed data input. This can save of our work times because we do not have to type the same data in each cell that we handle.

For this time we will take the example of a table that is in sheet1, while the data input feedbacks for the dropdown list menu will we put in sheet2.

Immediately, no strings attached, this is table will be handled looks like. You can create such table by visit our article about Excel Tutor : Creating a Table.

Here, we will create the table dropdown list menu in cell range of B3 to B17.

1. As the first step, we should prepare the data input to be used as a feedbacks of our dropdown list menu. Here I put the list of data input in sheet2 , as shown in the picture below.

2. After that, we will set up a source code to be entered into the Data Validation. Code generation will we did manually because we take the data input feedbacks on the different sheets with our tables that will be handled. I put the list of data input in sheet2 so the code should be like this, "= Sheet2! A1: A7", without the quotes of course huh !.

3. If the preparations was ready, we will start by determining of which range will be validated. As we will pointed out earlier, we will create a dropdown list menu in cell of B3-B17, then we highlighted the range.

4. Once the range of B3-B17 we highlighted, we go to the Data menu in the menu bar, Data > Data Validation. Data Validation Once we choose, there will appear a pop-up window. On the Settings tab, underneath there is a dropdown Allow: and we will select "List".

5. Under the list we will find the Source box. After that, enter the code that we created earlier which is "= Sheet2! A1: A7" without the quotes. Then click OK.

The result can be seen as shown in picture below.

That is!, our tutorials of this time. If this article about Creating Dropdown List Menu in Microsoft Excel Using Data Validation is useful, please share. Thanks Excelsor !.