Making a drop-down list in Excel lets you regularize your data and avoids making mistakes. You can add options such as YES or NO, FEMALE or MALE, or any other option to a cell too. Also, you are able to limit the value of other cells according to a cell containing a drop-down list. For example, when we select the Canada state, the cities of Toronto, Vancouver, and Montreal are displayed in another cell.
In this tutorial, we will learn about how to add a drop-down list in Excel. Also, we talk about:
Making lists of names
Creating a table
Naming a range
Adding a dependent list by indirect formula
Add a third dependent list
Add a Drop Down List
If you already have a list and only need to create a drop-down list, follow these steps:
Create a table.
Select the cell you want to enter the drop-down list.
Go to the Data tab,
Click on the DataValidation from the Data Tools section.
Go to the Setting tab from the DataValidation dialogue box.
Open the Allow menu, and pick the List.
In the Source box, enter the listed range you already have.
But if you need to make a list, the following tutorial will guide you through it. Also, we’re going to learn how to make a Professional drop-down list:
Making lists of names
First, you need a workbook containing two worksheets. We named the worksheets “Data” and “Lists.” So open Excel, on the bottom of the worksheet press on icon, and make a new sheet. By right-clicking on the Sheet1 and selecting Rename (or double click on the tab), you can change the name of sheet1 to Data (for this example), then press the Enter key on your keyboard.
In the Data sheet, we’ll enter lists of names. These lists provide the items needed for affiliate drop down lists. The lists are:
We believe this content can enhance our services. Yet, it's awaiting comprehensive review. Your suggestions for improvement are invaluable. Kindly report any issue or suggestion using the "Report an issue" button below. We value your input.
Contact us today at – and speak with our specialist.
BSUPERIOR SYSTEM LTD. provides custom software and technology solutions to small and medium sized businesses. We have been helping businesses to operate more efficiently, reduce money and time spend on redundant repetitive daily tasks.