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
   38   39   40   41   42   43   44   45   46   47   48