This free microsoft excel tips no 9 is telling to Make Data Validation. Sometimes we need someone that filled our data inquiry, limited in a given number range value. It is very vital to make 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
Incoming search terms:
- Powered by PHPDug open new tab to a search page
- Powered by PHPDug page editing software
- Powered by PHPDug data
- Powered by PHPDug computer networking degree online
- Powered by PHPDug microsoft video editing
- Powered by PHPDug open access
- Powered by PHPDug graduate degree
- Powered by PHPDug text box
- Powered by PHPDug field guide
- Powered by PHPDug mathematics lesson plans