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