Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 25 - 2632_CodeMind
P. 25

    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

| 20 21 22 23 24 25 26 27 28 29 30 |