Page 43 - Computer_Genius_v2.1_C7_flipbook
P. 43
Using Data Validation
Data validation means to restrict the user to enter a specific range of values in a particular cell or a
range of cells. Perform the following steps to use data validation:
2 Click on the 3 Click on the Data
Data tab. Validation command.
4 Select the Whole
number option from
the Allow drop-
down list.
5 Enter 0 and 100
values in the Minimum
and Maximum
textboxes respectively.
1 Select the cell or a range of cells on
which you want to apply data validation.
9 Select the Error Alert tab and
6 Select the Input type the error message in the Error
Message tab. message textbox.
7 Type Data
Validation in the
Title textbox.
8 Type Input message in the Input Message text area. 10 Click on the OK button.
Now, if you enter the number which is not in specified range, you will get an error message as shown:
Advanced Features of Excel 2016 41

