How to Create a Drop-Down List in Microsoft Excel?

 Brief Introduction

           In Microsoft Excel the Drop-Down List is a very powerful & useful tool to control the exact data which we want to enter in a specific cell or range of cells & also we can save our precious time. As we impress our boss through this powerful data Validation Tool.  

Purpose:

To control the exact data which we want to enter in a specific cell or range of cells.

              This article explains in simple terms how to create the Drop-Down List in Microsoft Excel. It takes a step-by-step approach, & the following below contents we will touch in this post.

• How to Create the Drop-Down List in Microsoft Excel.

• How to remove the Drop-Down List from Microsoft Excel.

Let’s start to learn something new about the Drop-Down List tool of Microsoft Excel.                

1.  How to Create the Drop-Down List in Microsoft Excel.

             Let's get started. First, we'll need to open our Microsoft Excel workbook & create any type of list like names of Animals, sports, countries & so on…, While in below example I have created the list of countries names which are approximately 198 names,

The second step in Drop-Down List creation is to select the cell or Range of Cells where we want to apply Drop-Down List tool, Now click on DATA Tab then click on Data Validation option.

        For continue reading the article & download free the Complete Practice of Concern Topic of Microsoft Excel File, Click on the below Learn More Button,