Page 73 - PlusGPT_V2.1_C7_Flipbook
P. 73

Copying/Moving Data

                 Just similar to Word 2016, data can be copied/moved in Excel 2016 also from one cell to another. 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.

                 Step 1:  Select the cells that you want to move or copy.
                 Step 2:  Click on Cut/Copy command in Clipboard group on Home tab to move/copy the content of
                          the selected cell.

                             To move cells, click Cut.
                             To copy cells, click Copy.

                 Step 3:   Click on the cell where you would like to paste the information.
                 Step 4:   Click on Paste command in the Clipboard group on Home tab to paste.















                                  Copying content of a Cell              Pasting content in a cell



                                                           Tech Hint

                          Similar to MS Word, Excel 2016 also allows us to use shortcut keys to copy, cut and
                                         paste the content of the cells. The shortcut keys are:
                                      To Copy: Ctrl + C       To Cut: Ctrl + X       To Paste: Ctrl + V






                      Using Undo and Redo Features
                 Similar to MS Word, Excel 2016 also allows to use the
                 Undo and Redo  commands. The Undo command  is
                 used  to  reverse the  previous  action  that  you  have
                 performed  in the worksheet.  With  the  help of this
                 command, you can reverse more than one actions.



                                                                                          Introduction to Excel 2016  71
   68   69   70   71   72   73   74   75   76   77   78