Page 53 - TP-Play_V-2.0_Book-5
P. 53

Modifying Cell Content


            Excel 2016 provides two ways to modify or change the content of a cell. One is
            editing the content in Edit mode and other is overwriting or replacing the entire
            content of the cell directly. To activate the Edit mode and change the content of a

            cell, follow the given steps:

            Step 1   Create a new workbook and enter some data into worksheet as similar to
                     the given data.

            Step 2   Double-click on the cell whose content you want to change. The Edit mode
                     is activated and a blinking cursor is appeared in the clicked cell.










                                1




                                             2




                      Edit mode
                        active
                                                    Editing cell content

            You can now make the required changes. After making all the changes, press the
            Enter key from the keyboard. The changed data is displayed in the cell.

                COPYING/MOVING DATA


            Just similar to Word 2016, data can be copied/moved from one cell to another in
            Excel 2016. Let us perform these operations.
            Cut, Copy and Paste Data


            We can use the Cut, Copy, and Paste commands in Microsoft Excel to move or
            copy entire cell content. When we use the Cut command, the content is moved to
            the new place and removed from its original place. In case of the Copy command,
            content is copied at the new place and also exist at its original place. The Paste
            command is used to paste the copied/cut data.

            When you move or copy a cell, Excel moves or copies the entire cell contents and
            cell formatting.





                                                                                   Editing in Excel 2016     53
   48   49   50   51   52   53   54   55   56   57   58