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. |