back to gallery
Click on the cell where you want the drop-down list to appear.
Go to the **Data** tab on the ribbon and click on **Data Validation** in the Data Tools group.
In the Data Validation dialog box, select **List** from the **Allow** drop-down menu.
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.
Click **OK** to close the dialog box. Click on the drop-down arrow in the selected cell to test your new drop-down list.