Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 75 - 2620_Birla Open Mind C-5
P. 75

    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  73

| 70 71 72 73 74 75 76 77 78 79 80 |