Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 77 - 2620_Birla Open Mind C-5
P. 77

    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  75

| 72 73 74 75 76 77 78 79 80 81 82 |