Formulas and Functions with Microsoft® Excel 2003 > Getting the Most Out of Ranges > Using Drag-and-Drop to Move a Range - Pg. : Creative Edge

Table of Contents

This Book

Formulas and Functions with Microsoft® Excel 2003

Formulas and Functions with Microsoft® Excel 2003

Search

Contents

URL

Help

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