Page 11 - KEC Khaitan C6 Flipbook
P. 11

Click here to select
                                 an entire Worksheet                           To select an entire
                                                                            SHORT KEY  CTRL +  A
                                                                               worksheet:












                           EDITING CELL CONTENTS


                 After entering the data in the cells, we can edit the data entered in the worksheet.

                 Cell contents can be edited in two ways.


                 REPLACING THE TEXT
                 Replacing the content means overwriting the data. The current content will be replaced
                 by the new entry. For this, we need to select the cell that we want to edit and then type the

                 new text to replace the old one.

                 MODIFYING THE TEXT

                 Modifying the text means correcting or modifying the content of the text without completely

                 replacing the text. We can modify the text in one of the three following ways:
                 Select the cell and press the F2 key on the keyboard. The cursor appears in the cell, and we can

                 begin to edit the content. Double-click on the cell. It will make the cursor appear on the screen
                 and then you can edit the text. Select the cell and then click on the formula bar to edit the text.




                           UNDO AND REDO COMMANDS


                 Excel 2021 provides the feature of reversing the last action. We use the Undo command to
                 reverse any action performed by us. To Undo, click on the Undo button in the Quick Access
                 Toolbar. If you wish to Undo many actions, click on the down arrow next to the Undo button.

                 The Redo command is used to redo the last
                 Undo action. The Redo command works only                     To Undo:
                 when you have given an Undo command. The

                 Redo  button  on the  Quick Access Toolbar              SHORT KEY  CTRL +  Z
                 stays inactive. To redo an action, click on the
                 Redo button in the Quick Access Toolbar.                       ALT    +   BACKSPACE





                                                                                               Editing in Excel 2021  9
   6   7   8   9   10   11   12   13   14   15   16