Page 52 - ThinkGPT_V2.1_C7_Flipbook
P. 52

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:



















                      50     Premium Edition-VII
   47   48   49   50   51   52   53   54   55   56   57