• 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 Move a Range

Using Drag-and-Drop to Move a Range

The drag-and-drop method for moving a range is identical to the one you learned for copying a range, except that you don't have to hold down the Ctrl key. Follow these steps:

1.
Select the range you want to move.

2.
Move the mouse pointer over any edge of the selection until you see a four-pointed arrow added to the regular pointer.

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

4.
When you've positioned the range border properly in the destination area, release the mouse button.

5.
If your moved range will paste over any nonblank cells, Excel asks whether you want to replace the contents of the destination cells. If everything looks reasonable, click OK to continue. Excel deletes the original range and pastes it in the destination.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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