How to add Drop Downlist in Excel 2010

Drop Downlist in Excel 2010

A drop down list allows you to enter data into an Excel from a list of data. This makes the data entry easier .

When a drop down list is created , an arrow next to the cell is displayed .You can enter the Data in the cell by selecting the data in the drop down list.

How to add Drop Downlist in Excel 2010 ?

It is quite easy to add the Drop Downlist in Excel 2010 .

To create the Drop Downlist in Excel 2010, first add the list for the datasource .

To create the list for the drop down ,enter the data in a single column cells

B4 – tiger
B5 – lion
B6 – elephant
B7 – dog
B8 – cat

The list can be added from the Data tab -> Data Validation ribbon .
Select the cell / column where the drop down list should be displayed and choose the datasource in the following window.

How to add Drop Downlist in Excel 2010

Now the dropdown list should appear as shown below.
Drop Downlist in Excel

There are other ways of creating Drop Downlist in Excel too with the different datasources…

You can find the series of posts on Excel , drop Downlists in Excel , and MSOffice in the MSOffice Category of the TechBlog-Ginktage