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.
There are other ways of creating Drop Downlist in Excel too with the different datasources…