Create Drop Down List In A Cell In Excel

This post demonstrate how to create a drop down list in a cell which will enable the user to select the value from the specified list in the drop down.

Users are restricted to select a value from the given list in a drop down in a cell in excel as shown below.




Capture

We will see how to create one in simple steps.

Step 1

Select the cell in which you want to have the drop down and go to Data Validation in Data tab.

Capture

Step 2




Select the List in Allow box and at the bottom select the source, source contains the values which will populate your drop down.

Capture

Press OK and your drop down is ready, alternatively you could provide the values of the drop down directly into the Source box separated by comma as shown below.

Capture

Hope this helped.

 

Share The Knowledge

Random Posts

Leave a Reply