Go to Data –> Data Tools –> Data Validation.
#1 Using Data from Cells Let’s say you have a list of items as shown below: Here are the steps to create an Excel Drop Down List: Select a cell where you want to create the drop down list.
HOW TO EDIT DROP DOWN LIST ON EXCEL MAC OS HOW TO
How to Create a Drop Down List in Excel In this section, you will learn the exacts steps to create an Excel drop-down list: Using Data from Cells. Watch Video – Creating a Drop Down List in Excel In this tutorial, you’ll learn how to create a drop down list in Excel (it takes only a few seconds to do this) along with all the awesome stuff you can do with it. Drop-down lists are quite common on websites/apps and are very intuitive for the user.
It can be used while getting a user to fill a form, or while creating interactive Excel dashboards.
Вы же любите тестировать, правда?Ī drop-down list is an excellent way to give the user an option to select from a pre-defined list. В Functions > Function выбрать Selection List.