Page 69 - TP_Plus_v4_Class4
P. 69

CHANGING CELL CONTENTS


                 You can change the contents of a cell by following the given steps:
                                                                   Click  in  the  formula bar and  enter the   1
                                                                   new data in the cell or the formula bar.



                                                                   Press Enter key or click on the   2
                                                                   Enter button on the formula bar.



                                                                                                        Hintbot
                 You can also change the data by double-clicking in the cell                  To edit a cell: F2 key
                 and start typing the new data.                                             It activates the “editing”

                                                                                            mode for the active cell.
                      UNDO AND REDO COMMANDS

                 You use the Undo command to erase the last change made or last action done to the worksheet.
                 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 and select the number of Undo Actions.
                 Redo  command  is  used  to  redo  the  last  Undo  action.
                 Redo command works only when you have given an Undo                                    Hintbot
                 command. The Redo button on the Quick Access Toolbar                          Shortcut to Undo:

                 stays inactive till Undo command is used. To redo an action,                       CTRL + Z
                 click on the Redo button         in the Quick Access Toolbar.                 Shortcut to Redo:
                                                                                                    CTRL + Y
                      COPYING AND MOVING DATA

                 You can easily copy and move the contents of a cell, a range of cells and an entire worksheet.
                 This is similar to the copy and move commands in Word 2019.

                 Copy/Move the Data

                 To copy/move the data, follow the given steps:

                       2
                           Click on the Home tab.                                         Select Copy/Cut     3
                                                                                          command.




                           Select the  cells you
                       1
                           want to copy/move.

                                                                                          Click on the cell
                                                                                          where  you  want
                                                                                          to copy/move. the      4
                                                                                          selected range.




                                                                                    #Editing Cell Contents in Excel 2019  67
   64   65   66   67   68   69   70   71   72   73   74