Page 21 - TP_Pluse_V2.2_Class_6
P. 21

We can also select a range of cells by using the Shift key. Click on the first cell and then press and hold
                 the Shift key down, and click on the last cell up to which we want to make a selection.
                   Unrelated or Discontinuous Cells: Click on the first cell to be selected then hold the Control Key
                   and continue selection of the unrelated cells while holding on
                   the Control key.                                                         Tech Hint

                   Entire Row/Column: Click on the row heading to select the          To select entire worksheet:
                   entire row or click on the column heading to select the entire               Ctrl + A
                   column.
                   Entire Worksheet: Click on the Select All button       located below the Name box to select the
                   entire worksheet.


                      Modifying Cell Content

                 Excel provides two ways to modify or change the contents of a cell. One is editing the content in Edit
                 mode and the other is overwriting or replacing the entire content of the cell directly. To activate the
                 Edit mode and change the content of a cell, follow these steps:
                 Step 1:  Create a new workbook and enter some data into a worksheet as similar to the given data.

                 Step 2:   Double-click on the cell whose contents we want to change. The Edit mode is activated and a
                         blinking cursor appears in the clicked cell.














                          Edit
                         mode
                                                           Editing cell content
                 Step 3:   We can now make the required changes. After making all the changes, press the Enter key
                         from the keyboard. The changed data is displayed in the cell.

















                                                          Content after editing

                 To replace the entire contents of a cell, follow these steps:
                 Step 1:  Click on the cell whose contents we want to replace.


                                                                                              More on Excel 2016   19
   16   17   18   19   20   21   22   23   24   25   26