How to add Dropdown in excel 2021

How to add Dropdown in excel 2021

The Excel spreadsheet for many newbies may appear technical and maybe boring as well. Considering the number of rows and columns with its no user-friendly interface, just some multiple boxes with fields. Ok! Maybe it’s a tiny bit boring without the formulas; once you have found your way around the application and you further are proficient with the formulas, you, my friend should be celebrated.

One of the many features of Excel is the Drop-down which finds vast applications when creating a list. a drop-down list is a small window through which you can view other data that you have created. It is also understood as a list with an excellent way to provide the user with the option of choosing from a pre-defined list. The Drop-down finds common use on websites/apps to fill out a form or to create interactive Excel dashboards and is quite user-friendly. 

How about we get started already, shall we?

CREATING A DROP-DOWN WITH EXISTING DATA

In this first method of creating a drop-down list in Excel, we're assuming you already have a working list of items you want to use in your drop-down list in your spreadsheet.

Step 1: 

Choose a cell for your drop-down list.

Check that this is the cell you want to use for the drop-down list so you don't have to change it later.

Step 2: 

Navigate to the Data tab and select Data Validation.

This activates the Data Validation dialog box.

Step 3: 

On the Settings tab, under Allow, select List. If it isn't already checked, check the In-cell dropdown box.

Step 4: 

Select the Source field. Then, with your mouse pointer, click and drag over all of the cells that contain the items you want to use for your drop-down list.

This selects all of the cells at once and automatically populates the Source field with the data you need for your drop-down list.

Step 5: 

Press the OK button.

CREATING A DROP-DOWN MANUALLY

Let us assume you fall into the category of not having an existing list in your spreadsheet to work with, when using this second method, you'll have to enter the desired items manually. 

Please follow the steps outlined above as a guide, then:

Step 1: Choose a cell for your drop-down list.

Step 2: Navigate to the Data tab and select Data Validation to open the Data Validation dialog box.

Step 3: Navigate to the Settings tab. If it isn't already checked, check the In-cell dropdown box.

Step 4: Select the Source field. Then, for your drop-down list, enter each item one at a time, separated by a comma.

Step 5: Press the OK button.

CREATING MULTIPLE DROP-DOWN

If you intend to create several of the same drop-down lists at once, I'm glad to let you know that the process is just as easy as creating a single drop-down list. What differs is that you’re selecting several cells, which implies the cells you want your drop-down lists in.

Please see the steps below for your guide.

Step 1: 

Determine which cells will be used for the drop-down lists.

Step 2: 

Navigate to the Data tab and select Data Validation to open the Data Validation dialog box.

Step 3: 

On the Settings tab, under Allow, select List. If it isn't already checked, check the In-cell dropdown box.

Step 4: 

Select the Source field. Then, with your mouse pointer, select all of the cells that contain the items you want to use in your drop-down list. If you intend to enter the items manually, simply enter each item one at a time, separated by a comma.

Step 5: 

Press the OK button.

There you go; you are now a Pro! 

For more details on Windows and other Operating Systems, Website Development, Digital Marketing, and SEO, you can always trust The Watchtower, the best and award-winning Website Development Company, Dubai 

  • Share:

Comments (0)

Write a Comment