Japanese version. Setting a “Data Validation” for a cell can be accomplished, for example, by restricting input to numbers only, or by displaying a drop-down list of candidates from which the user can choose. How to use Set up Select the cell you wish to set and choose “Data Validation” under “Data”. Allow Any value Initial state. No input restrictions. Whole number Restrict input to integers. Under “Data,” set the type of restriction. In the example below, only 1 to 100 is allowed. If “Ignore blank” is checked, no restriction will be imposed when the cell contents are blanked. If unchecked, no whitespace is allowed. Decimal Restrict to a small … Continue reading Data Validation.(Microsoft Excel)