Page 26 - ThinkGPT_V2.1_C6_Flipbook
P. 26

Naming a Cell Range

                  Excel allows us to assign a name to a cell range. This name can be used in place of cell address in
                  formulas. To assign a name to a cell range, follow the given steps:


                                          2  Click on the
                                          Formulas tab.




                                                                                           3  Click on the Define
                                                                                          Name button.



















                                             1   Select  the  range  of  cells  to  which
                                            you want to assign a name.

                  The New Name dialog box appears on the screen.


                                                    4  Type the Name.





























                                                   5  Click on the OK button.

                  Now, we can use this name in place of the cell address in formulas.




                       24    Premium Edition-VI
   21   22   23   24   25   26   27   28   29   30   31