Monday, 28 November 2011

How to add drop down list in excel sheet

If you are struggling to add dropdown list in excel sheet, for example: rows have following values a, b, c and d. And you want a drop down list on top of these rows to display all these mentioned values then here is solution for you.
1. Open MS excel.
2. Click on the Data tab (present on top of the excel) and click on Data validation tab.










3. Under setting tab (default tab in data validation window), and select List item fromAllow drop down field.






Note: Make sure you have selected the cell in excel where you want to add the drop down list field.
 4. Click on the image (present on right side) of the Source field), new pop up will open & again click on that similar image and select the range that you want to see in the drop down list. (Check in screenshot).
Note: That range will populate in Data validation (step 2) pop window and click Ok to save it. 








5. You can see the drop down with items (range that you added), in an excel sheet. If you want to display same drop down on other cell, just copy cell where you just created list and paste to the new cell.

No comments:

Post a Comment