Wednesday, 4 December 2013

Data validation/combo box on cells in excel

Steps:
1. Select a Column or cells that you want to make a combo box
2. On the menu tab click data and find 'data validation' and click it.
3. Below the validation criteria, Select List on the options,
4. Type the list you want on the 'Source Box'


You can watch the video here :
http://youtu.be/RYU6wuRChp0

No comments:

Post a Comment