Steps to Create Drop-Down Lists
Step 1: Go to the Formulas Tab and Select Create from Selection
Go to the Formulas tab, you will find an option Clear from Selection.
Step 2: Select the Column
Select the column, you want to create a named range, here E6:E11.
Step 3: Click on Create from Selection
Click on the Create From Selection and a pop-up appears.
Step 4: Select Top Row
This pop-up tells from which value you want to create a named range. More generally we will be using the Top row. The top row specifies that the name of the selected range will be the value written in the Top row. Click ok and a named range is obtained from E6:E11.
Step 5: Click on the Name Box and Select the option
Click on the Name box and you will find Web Development added to the Name box list.
Step 6: Redirected to the Data
By clicking on the Web development in the Name box, you will be directed to E7:E9. With this, you could be redirected back to the name range despite you being anywhere in your worksheet.
Step 7: Repeat for Data Structure and Data Analytics
Similarly, create a named range for Data Structures and Data Analytics.
Step 8: Currently, you might not be able to understand the benefit of Create from Selection but as soon as you will study Dependent Dropdown List in Excel, you will understand the power of Create from Selection.
Note: The Scope of Create with Selection is in a work book and not in an individual Worksheet. i.e. if you create multiple worksheets then also the list inside the Name Box will retain itself.
How to Create a Dependent Drop Down List in Excel
Dependent Down Lists allow you to validate the data and make the data entry and data filtering very smooth and time-saving. Dependent Down Lists increase the chances of fewer errors in one’s worksheet. The prerequisites for learning Dependent Drop Down List are Create from Selection and Drop Down List.
Sometimes you may want to use more than one drop-down list in Excel, Such that the items available in the second Drop-down list are dependent on the selection made in the first drop-down list. These are called Dependent drop-down lists.
Contact Us