Page 58 - Code & Click - 6
P. 58

Using the Undo Command                                                  1

            •  To cancel the recent most action, click the Undo
                   button on the Quick Access toolbar.

            •  To cancel a series of recent actions:                       2
              1.  Click  the  down   arrow next to Undo
                  button on the Quick Access toolbar.
              2.  Click the action in the list up to which you want
                  to cancel the actions.

                           1



                                                      Using the Redo Command
                                                      •   To  reverse  the  last  cancelled  action,  click  the  Redo

             2                                          button on the Quick Access toolbar.
                                                      •  To reverse a series of recently cancelled actions:
                                                        1.  Click the down   arrow next to Redo       button on the
                                                            Quick Access toolbar.
                                                        2.  Click the action in the list up to which you want to
                                                            reverse the actions.


            COPYING AND MOVING CELL CONTENTS
            You can copy or move the contents of a range of cells
            from  one  location  to  another  location  in  the  same       2
            worksheet or in a different worksheet.
            To copy or move the contents of cells:
              1.  Select the range of cells whose contents you want
                  to copy or move.                                          1
              2.  On  the  Home  tab,  click  the  Copy  button  or  Cut
                  button in the Clipboard group to copy or cut the
                  contents.

                  A moving  dashed outline  appears  around  the
                  selected range of cells.

              3.  Select the new location where you want to paste           4
                  the contents.

              4.  On  the  Home  tab,  click  the  Paste  button  in  the
                  Clipboard group.


                  Excel copies or moves the contents of the selected                                       3
                  range of cells to the new location.
                                                                    Time Saver
              5.  Press the Esc key to deselect the cells.           Copy: Ctrl + C      Cut: Ctrl + X   Paste: Ctrl + V




            56
   53   54   55   56   57   58   59   60   61   62   63