Basic HTML Version

|  | Table of Contents |  | View Full Version

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

| 80 81 82 83 84 85 86 87 88 89 90 |