How to create a drop down list in Excel?

With continuous effort, you can make drop down lists in Excel in less than 15 seconds. Hope we were able to render you with the easiest approach.

Must Read

Top 10 Porn Apps: From a Developer’s Point of View

Article Index: 1. Introduction 2. The Top 10 Porn Apps 2.1 Youporn 2.2 Pornhub 2.3 Perfect Girls 2.4 Literotica 2.5 Vporn 2.6 Yes Porn Please 2.7. XMovie 2.8 Perfect...

What is Pro Kabaddi League? Details of the Pro Kabaddi League 2020, 2019, 2018 and 2017:

Article Index: Introduction History of Pro Kabaddi League The Inception of the Pro Kabaddi League Initial Success of the...

CricBuzz: All you need to know about India’s Biggest Cricket App

Article Index: 1. Introduction 2. What is CricBuzz? 3. The History of CricBuzz 4. The Popularity of CricBuzz 5. The Salient features of Cricbuzz   1....
Saumya Uniyal
Saumya Uniyal
Saumya has completed her Diploma in Mass Communication & aims to make a mark as a writer. She's an avid learner & a tech enthusiast striving to gain knowledge in her interested areas, including the latest technological advancements.

Introduction

Excel sheets have always assisted us in providing an excellent, organized database for the execution of tasks and plans. A drop down list in Excel is beneficial if one wants a user operating a worksheet to pick an item from the list, rather than typing the values manually. 

The Excel drop down list creates your control on the worksheet by restricting the users to choose a value from a curbed catalog designed exclusively by you. For beginners or amateurs Excel users, creating a drop down list in Excel might look like a complicated task, but with your first attempt, you’ll be able to excel at Excel in just a few steps!

 

7 Steps to create an Excel drop down list:

1. Type items to be added on the list

In Excel, open Sheet2 and type the items you desire to be added to your list in a column of your choice. Let’s say you’ve added the items in column A from A1 to A10. 

 

2. Convert cells into a table

In case you don’t have entries in a table, you can select the cells to convert your list into a table by selecting the cell range and pressing Ctrl+T. 

 

3. Select cell for the drop down list to be placed on

Go back to Sheet1 and select the cell where you desire to have the Excel drop down list placed.

 

4. Click on Data>Data Validation

Next, click on the Data tab from the displayed arrangement of tabs in the topmost row on the Excel window and then select Data Validation.

 

5. Select ‘List’ option under Settings>Allow 

The Data Validation window will pop-up on the screen. Under the Settings tab, select the List option from the Allow box.

 

6. Type list range under Source sub-head & click OK

Now, under the Source box type your list range. In our case, the Source would be ranging from A1 to A10, i.e., ‘=Sheet2!A$1:$A$10’, and click on OK.

 

7. Drop down list has been added!

Your drop down list will be added on the selected cell containing all your options.

 

Further information to make your drop down list excel

There are specific additional facts that one must know to make their Excel tasks easier. Here’s a list of facts about drop down list Excel: 

1. Create list directly in the Source box

You can also manually type the list options under the Source box by separating each entry by a comma (,). However, since the drop down list is case-sensitive, it is necessary to type each option with the first letter capitalized. 

 

2. Add, Subtract & Edit list

You can add, subtract & edit items from your list by going back to the Sheet2 & altering the entries accordingly. The list will automatically be updated on Sheet1.

 

3. Key to a professional spreadsheet

While representing or sharing the worksheet with colleagues, you can hide Sheet2, making the spreadsheet look more professional

Remember, practice makes you perfect. With continuous effort, you can make such drop down lists in Excel in less than 15 seconds. Hope we were able to render you with the easiest approach to conclude an entirely beneficial & productive way to create a list. 

Leave A Reply

Please enter your comment!
Please enter your name here

Hire Dinosoft

At DinoSoft we help boost your business by providing tailor-made solutions for web development, SEO & marketing with our best in-house software developers striving to attain & deliver quintessential results.

Latest Articles

Top 10 Porn Apps: From a Developer’s Point of View

Article Index: 1. Introduction 2. The Top 10 Porn Apps 2.1 Youporn 2.2 Pornhub 2.3 Perfect Girls 2.4 Literotica 2.5 Vporn 2.6 Yes Porn Please 2.7. XMovie 2.8 Perfect...

What is Pro Kabaddi League? Details of the Pro Kabaddi League 2020, 2019, 2018 and 2017:

Article Index: Introduction History of Pro Kabaddi League The Inception of the Pro Kabaddi League Initial Success of the Pro Kabaddi League Pro Kabaddi...

CricBuzz: All you need to know about India’s Biggest Cricket App

Article Index: 1. Introduction 2. What is CricBuzz? 3. The History of CricBuzz 4. The Popularity of CricBuzz 5. The Salient features of Cricbuzz   1. Introduction: CricBuzz owned by Times Internet was one of...

What is Functional Programming? Its History, Characteristics, Benefits and Limitations

Article Index: 1. Introduction 1.1 What is Functional Programming? 2. Characteristics of Functional Programming 3. History of Functional Programming 4. Some Prominent Functional Programming Languages 5. The Benefits of Functional...

8 Best Kids Coding Languages: Easiest Coding Languages for Kids

Article Index: 1. Introduction 2. Why is coding necessary to learn for kids? 3. Are all coding languages natural to learn for kids? 4. The Eight Best Coding...

More Articles Like This