Page 22 - Plus_V2.2_C6_Flipbook
P. 22

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.
                      Entire Row/Column: Click on the row heading to select the entire row or click on the column heading

                    to select the entire column.
                      Entire Worksheet: Click on the Select All button located below         Tech Hint
                    the Name box to select the entire worksheet.                       To select entire worksheet:
                                                                                                 Ctrl + A
                       Modifying Cell Content

                  Excel provides two ways to modify or change the content of a cell. One is editing the content in Edit
                  mode and 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 worksheet as similar to the given data.

                  Step 2:   Double-click on the cell whose content 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 content of a cell, follow these steps:
                  Step 1:  Click on the cell whose content we want to replace.
                  Step 2:  Start typing new content. After typing the content, press the Enter key from the keyboard.






                  20    Premium Edition-VI
   17   18   19   20   21   22   23   24   25   26   27