We named the worksheets “Data” and “Lists.” So open Excel, on the bottom of the worksheet press on icon, and make a new sheet. Also, we’re going to learn how to make a Professional drop-down list: Making lists of namesįirst, you need a workbook containing two worksheets. In the Source box, enter the listed range you already have.īut if you need to make a list, the following tutorial will guide you through it.Open the Allow menu, and pick the List.Go to the Setting tab from the Data Validation dialogue box.Click on the Data Validation from the Data Tools section.Select the cell you want to enter the drop-down list.If you already have a list and only need to create a drop-down list, follow these steps: Adding a dependent list by indirect formula.In this tutorial, we will learn about how to add a drop-down list in Excel. ![]() ![]() For example, when we select the Canada state, the cities of Toronto, Vancouver, and Montreal are displayed in another cell. Also, you are able to limit the value of other cells according to a cell containing a drop-down list. ![]() You can add options such as YES or NO, FEMALE or MALE, or any other option to a cell too. Making a drop-down list in Excel lets you regularize your data and avoids making mistakes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |