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

Chapter 1. Getting the Most Out of Ranges > Using Drag-and-Drop to Copy a Range

Using Drag-and-Drop to Copy a Range

If you have a mouse, you can use it to copy a range by selecting the range and then clicking and dragging it to the appropriate destination. There are no menus to maneuver and no risks of accidentally overwriting data because you can see exactly where the copied range will go. The following steps show you how to copy a range:

1.
Select the range you want to copy.

2.
Hold down the Ctrl key.

3.
Move the mouse pointer over any edge of the selection (except the fill handle!). You'll know you've positioned the mouse pointer correctly when it changes to an arrow with a plus sign (+).

4.
Click and drag the mouse pointer to the destination range. Excel displays a gray outline that shows you the border of the copy.

5.
When you've positioned the range border properly in the destination area, release the mouse button and then the Ctrl key (in that order). Excel pastes a copy of the original range.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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