Page 67 - TP_Pluse_V2.2_Class_5
P. 67

To change the data partially, follow the steps:                                     3         2

                 Step 1:   Click on the formula bar or double-click on the cell
                         where you want to edit the data. The cursor appears
                         in the cell.
                 Step 2:  Enter the new data in the cell or the formula bar.
                                                                                                        1
                 Step 3:   Press  Enter key or click on the  Enter button on the
                         formula bar. The cell data is changed.


                        UNDO AND REDO COMMANDS


                 You use the Undo command to erase the last change made to the worksheet or your last
                 action. To undo click on the Undo button on the Quick Access Toolbar. If you wish to undo
                 many actions, click on the down arrow next to the Undo button            .

                 Redo command is used to redo the last Undo action. Redo command works only when you
                 have given an Undo command. The Redo button on the Quick Access Toolbar stays inactive.
                 To redo an action, click on the Redo button         on the Quick Access Toolbar.


                        COPY AND MOVE 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 2016.


                      Copy Data

                 To copy data, follow the given steps:

                 Step 1:   Select the cells you want to copy. We have selected the range B3:C4.

                 Step 2:  Click on the Home tab.

                 Step 3:  Select Copy button from Clipboard group.
                         Or

                           Right-click and choose Copy option from the context menu or press Ctrl+C keys.

                           A dashed border appears around the selected cells. Notice that the range B3:C4 has
                         a dashed border around it.

                 Step 4:   Click on the cell where you want to copy the selected range.

                 Step 5:  Select Paste button in clipboard group.

                         Or

                           Right click and choose Paste option from the context menu or press Ctrl+V keys.





                                                                                  Editing Cell Contents in Excel 2016  65
   62   63   64   65   66   67   68   69   70   71   72