Add a Drop-Down List in Excel 2007,2010

Ever wondered how some worksheets have some drop-down list? Do you have to learn a very complicated macro or programming to do it on your own worksheet? Worry not, it is so easy. After learning this, you will be able to add this to your worksheet and make your worksheet look professional (and hopefully more user friendly). Here's the procedure.

1. Input all the data you want included in the drop-down list in a series of cells (example: A1:A5)
2. Click on the DATA tab in the ribbon
3. Select Data Validation
4. On the settings tab of the data validation dialog box, under "allow", choose list
5. Under the source box, input the list  of data (in this case A1:A5)
6. Now, you have a drop-down list. Well done!

Data validation on the ribbon

Data validation dialog box

Drop-down list in excel

            

               

Now, your worksheets will look more professional and you'll look more like an excel expert!

Happy Computing!

Tweet