Page 68 - TGPT_V5.0_C5_Flipbook
P. 68

Selecting a Range of Cells

                                                          A range is a rectangular section of cells which are next
                                                          to each other and at least one side of their border is

                                                          common. A range is defined by the cell addresses of
                                                          the top left cell and the bottom right cell with a colon (:)
                                                          in between. For example, the range address is B2:D10.
                                                          B2 is the address of the top left cell. D10 is the address

                                                          of the bottom right cell.

              To edit the contents in a range of cells, you have to select
              the range.


              Using the Mouse

              To select a range of cells using a mouse: First click in the
              top left cell and drag to the bottom right cell. The range
              gets selected. All the selected cells get highlighted.  Only

              the active cell is not highlighted.

              Using the Keyboard

              You can also select a range by clicking the top left cell. Then keeping the Shift key pressed, click
              on the diagonally opposite bottom right cell. The range will be selected.





                                                   Selecting Multiple Cells

                                                   To select a group of cells which are not next to each other,
                                                   click on the first cell. Now, keeping  the  Ctrl key pressed

                                                   click on the other cells to select. All the selected cells will be
                                                   highlighted.





              Selecting the Whole Worksheet

              To select the whole worksheet, click the Select All triangle.
              This button is present above row 1.















                  66  Premium Edition-V
   63   64   65   66   67   68   69   70   71   72   73