• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Using Excel > Task 5 How to Move and Copy Data

Task 5 How to Move and Copy Data

If you have to move or copy data to another location on a worksheet, and the new location is only a short distance from the original location, the easiest way to accomplish your goal is to drag the data and drop it with the mouse. Whether you're moving or copying a single cell or a range of cells, the drag-and-drop method makes it easy and fast.

  1. Select Cells to Move

    To move cells, first select the range of cells you want to move. Point to any border of the selected range so that the mouse pointer becomes an arrow with a cross-hair underneath.



  2. Drop the Cells

    Drag the range to a new location. While you drag, an outline of the range moves across the worksheet, and a ScreenTip tells you the reference of the current range location. When the range border is where you want it, drop the data by releasing the mouse button.



  3. The Range Moves

    The range moves to its new location.



  4. Select Cells to Copy

    To copy cells, select the range of cells you want to copy and point to any border of the selected range so that the mouse pointer becomes an arrow. Drag the range to a new location.



  5. Drag the Cells

    While you drag, an outline of the range moves across the worksheet, and a ScreenTip tells you the reference of the range location.



  6. Press Ctrl and Drop the Cells

    When the range border is where you want it, press and hold the Ctrl key and drop the data by releasing the mouse button. When you press Ctrl, the mouse pointer acquires a small plus symbol that tells you it's copying. A copy of the data is dropped in the new location.




PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint