How to Create a Drop Down list in Microsoft Excel 2013 to use Data from different Worksheet?

In my previous blog post, I showed How to Create a Simple Drop Down list in Microsoft Excel 2013 using the data from the same worksheet.

In this blog post, I will demonstrate how one could create a Drop Down list in Microsoft Excel 2013 to use Data from different Worksheet.

How to Create a Drop Down list in Microsoft Excel 2013 to use Data from different Worksheet?

1. Let’s enter the following data in the worksheet 1

A1 – Senthil Kumar

A2 – Senthil

A3 – Kumar

A4 – isenthil

A5 – Senthil Kumar B

2. Drag the Cells A1 to A5 and right click and then select “Define Name” from the context menu. Let’s provide the name “First Name” to it and click OK.

3. Now, go to the Worksheet 2 and select the cell/column where you want the dropdown list to be shown and then click the Data Tab.

4. Navigate to Data Validation Dialog by clicking the Data Validation button from the Data Validation combo box defined in the Data Tools.

5. In the Settings Tab , select the option “List” in the Allow Drop down and in the Source text box enter =FirstName and click OK.

6. Now, you should see the dropdown list being created in the selected column of the excel worksheet 2 with the predefined values from worksheet1.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


x

Interesting BlogPosts to read

How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...
How to hide page breaks in worksheets in Microsoft Excel ?
When the page breaks is used to adjust the print area in a worksheet in excel , this would show up a...
How to protect all worksheets at once in Excel using VBA ?
Assume that you have a worksheet and you wish to protect all of the worksheets with a password at on...