Page 67 - TP_Plus_v4_Class4
P. 67

Selecting a Range of Cells

                                                            A range is a collection of selected cells. It 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. Selection of a range of

                 cells is done by -

                 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 visible as 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 multiple  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.


                                                   Hintbot


                                         To select the entire
                                         worksheet: Ctrl + A




                                                                                    #Editing Cell Contents in Excel 2019  65
   62   63   64   65   66   67   68   69   70   71   72