Moving Cells Using the Mouse

As you edit your worksheet, you can use the mouse to move cells from one location to another. You do this by following these steps:

1. Select the range of cells you want to move by highlighting the range with the mouse.
2. Position the mouse pointer over the heavy border that surrounds the selected range. The pointer should turn into an arrow.
3. Click and drag the range to a new location. As you move the mouse, the outline of the range moves.
4. When you are satisfied with the new location, release the mouse pointer. The cells are moved.

If there is anything already at the target location, Excel may ask you if you want to overwrite the existing cells. You can respond according to your desires.

If you cannot seem to edit this way, or if no heavy border (step 2) appears around your selected range, then drag-and-drop editing is probably turned off on your system. To check this, follow these steps:

1. Choose Options from the Tools menu. This displays the Options dialog box.
2. Click on the Edit tab. (Click here to see a related figure.)
3. Make sure the Allow Cell Drag and Drop check box is selected.
4. If you want to be warned before overwriting information during an edit, make sure the Alert Before Overwriting Cells check box is selected.
5. Click on OK.