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:
- Select the range of cells you want to move by highlighting the range with the mouse.
- Position the mouse pointer over the heavy border that surrounds the selected range. The pointer should turn into an arrow.
- Click and drag the range to a new location. As you move the mouse, the outline of the range moves.
- 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:
- Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In later versions of Excel display the File tab of the ribbon and click Options.)
- Click the Advanced option at the left of the dialog box. (See Figure 1.)
- In the Editing Options area, make sure the Enable Fill Handle and Cell Drag-and-Drop check box is checked.
- If you want to be warned before overwriting information during an edit, make sure the Alert Before Overwriting Cells check box is selected.
- Click on OK.
Figure 1. The Advanced option of the Excel Options dialog box.