Page 46 - modular4.0
P. 46

Chapter Profile
                         UNDERSTANDING CELL RANGE


                  A group of selected cells is called a range. The selected cells should be in continuation to form a

                  range. When a range is selected in a worksheet, a rectangular shape is formed. We can use a cell

                  range to perform a calculation on multiple cells. The address of a range is created by using the
                  starting and the ending cell addresses separated by a colon (:) sign. For example, if we have selected
                  the cells from B2 to E3 then the address of the range will be B2:E3.


                  Selecting a Range in a Worksheet
                  We can select a range by using the mouse and by using the Shift key. Perform the following steps
                  to select a range:

                                                                                    2  Press and hold the left
                             1  Click on the first
                            cell from which you                                     mouse button and drag
                            want to start the                                       the  mouse  diagonally  or
                            range.                                                  hold the  Shift key and
                                                                                    click  on  the  last cell  to
                                                                                    select the desired range.

                  The range gets selected.

                  Naming a Cell Range
                  Excel 2019 allows us to assign a name to a cell range. This name can be used in place of cell address
                  in formulas. Perform the following steps to assign a name to a cell range:

                                2  Click on the Formulas tab.      3  Click on the Define Name command.


















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


                     4  Type the
                     name.










                                                5  Click on the OK button.


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


                44   Modular (Ver. 4.0)-VII
   41   42   43   44   45   46   47   48   49   50   51