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

Chapter 12. Making It Look Good > Moving and Copying Data

Moving and Copying Data

Excel's drag-and-drop capability makes moving and copying data especially easy.

To move or copy a range of cells:

1.
Select the range of cells to move or copy (Figure 12.15).

Figure 12.15. Select a range of cells.


2.
Place the pointer on the border of the range so that the pointer becomes a hand (Figure 12.16).

Figure 12.16. Place the pointer on the range border; it changes to a hand.


3.
To move the cells, drag the border of the range to move the range to a new location (Figure 12.17). A yellow ScreenTip appears to indicate the destination.

Figure 12.17. Drag the border to move the range.


or

To copy the cells, hold down while dragging the border of the range. A small plus appears inside the pointer hand to indicate that you are copying rather than moving (Figure 12.18).

Figure 12.18. The plus sign appears in the hand to indicate that the range is being copied rather than moved.


4.
Release the mouse button to drop the range at the new location (Figure 12.19).

Figure 12.19. When the mouse button is released, the range is moved or copied.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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