Page 85 - 2619_PlusGPT V2.1_C-7
P. 85
UNDERSTANDING CELL RANGE
In Google Sheets, a group of selected cells is called a range. To create a range, the selected cells
should be next to each other. When you select a range in a worksheet, it will form a rectangular
shape. You can use a cell range to perform calculations on multiple cells at once. The address of a
range is written by combining the starting cell address and the ending cell address, separated by
a colon (:). For example, if you select cells from B2 to E3, the range address will be B2:E3.
Selecting Range in a Worksheet
You can select a range in a worksheet by two methods:
By using the Mouse
Follow the given steps to select the range of cells by using mouse:
Step 1: Click on the cell from where you want to select a range.
Step 2: Press and hold the left mouse button, then drag the mouse diagonally to select the
desired range.
Step 3: Release the mouse button on the last cell you want to select. The range will then be
highlighted.
By using Keyboard
Follow the given steps to select the range of cells by using keyboard:
Step 1: Move to the cell from where you want to select a range by using Arrow keys.
Formulas and Functions in Google Sheets 83
