back to gallery
how to create a drop down list in excel
5 steps
1
Select the Cell
Click on the cell where you want the drop-down list to appear.
2
Open Data Validation
Go to the **Data** tab on the ribbon and click on **Data Validation** in the Data Tools group.
3
Choose List Option
In the Data Validation dialog box, select **List** from the **Allow** drop-down menu.
4
Enter List Items
In the **Source** field, enter the items for your drop-down list separated by commas (e.g., Item1, Item2, Item3) or select a range of cells that contain the list items.
5
Finish and Test
Click **OK** to close the dialog box. Click on the drop-down arrow in the selected cell to test your new drop-down list.
Documents you might like
Copyright © 2024 Notta. All Rights Reserved.