Excel Tips No 9 : Create Data Validation

This free microsoft excel tips no 9 is telling to Create Data Validation. Sometimes we need someone that filled our data inquiry, limited in a given number range value. It is very important to create a standard value in the questionnaires to get valid analytical result.


Here the step to do this

1. Select cell that data will be filled in (ie, Cell C5)
2. Click Menu Data - Data Validation
3. Fill Allow field by List
4. Make sure check in-cell drop down option
5. In Source Field, filled cell range for value validation. You can click red arrow and block cell range for value range, ie Cell E5:E9
6. Click Done.
7. Copy this cell (ie, cell C5) to another cell that will be filled a data/value.



May this data can be usefull for you