Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 24 - 2632_CodeMind
P. 24

    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 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.
                     By using the Mouse

                     To select a range by using the mouse, follow the given steps:

                                                1  Click on the first cell from which
                                                you want to start the range.

                                                   2  Drag the mouse towards the cell up to
                                                   which you want to make the selection.

                     By using the Shift Key

                     To select a range by using the Shift key, follow the given steps:

                                                   1  Click on the first cell from which you want
                                                   to start the range.

                                                 2  Press and hold the Shift key and click on the last
                                                cell up to which you want to make the selection.

                     When the Shift key is released. The range gets selected.

                                                                                  Formulas and Functions in Excel  23

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