Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 11 - 2615_KEC
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 |