Notta
Showcase

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

lighting effect

Start creating your guide online

Automate guide creations and save your time into things that matter.

Notta
Showcase
Copyright © 2024 Notta. All Rights Reserved.