Page 25 - CG_v2.1_flipBooks_class_6
P. 25
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

