Page 43 - Computer Genius Class 07
P. 43
Using Data Validation
Data alidation means to restrict the user to enter a specific range o alues 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.
o i you enter the num er hich is not in specified range you ill get an error message as sho n
Advanced Features of Excel 2016 41

