opkgrupo.blogg.se

Instructions on How to Add a Drop Down List in Excel Then select the cells where you want to show the drop downs lists and use the “Data Validation” tool to provide the user with a drop down list in those cells from which they can select a choice from the initial list of values you entered. To learn how to add a drop down list to Excel, first type the list of values you want the drop down list to display into a column within the Excel worksheet. You accomplish this in Excel by using the “Data Validation” feature. In this lesson, you will learn how to add a drop down list in Excel within a worksheet. Overview of How to Add a Drop Down List in Excel