Page 57 - TP_Prime_v2.2_Class_5
P. 57

Selecting a Row

                 To select a row, follow these steps:

                 Step 1:   Place the mouse pointer on the row header of the row to be selected. The
                           mouse pointer will change to an arrow.

                 Step 2:   Click on the row header, the entire row gets selected.

                   Selecting a Column                                                                                       INTRODUCTION TO EXCEL 2016


                 To select a column, follow these steps:
                 Step 1:   Place the mouse pointer on the column header of the column to be selected.

                           The mouse pointer will change to an arrow.
                 Step 2:   Click on the column header, the entire column gets selected.

                   Selecting a Range of Cells
                                                                                                                          55
                 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 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.
   52   53   54   55   56   57   58   59   60   61   62