Microsoft Office Tutorials and References
In Depth Information
Moving and copying with the mouse
If direct cell manipulation doesn’t seem to be working, click the File tab, click Options,
and in the Advanced category under Editing Options, check that the Enable Fill Handle
And Cell Drag-And-Drop option is selected.
Figure 8-7 Before you finish dragging, press Ctrl to copy the selection. A plus sign and
destination reference appear next to the pointer.
You can also use direct cell manipulation to insert copied or cut cells in a new location,
moving existing cells out of the way in the process. For example, in the first image in Figure
8-8, we selected cells A6:E6 and then dragged the selection while holding down the Shift
key. A gray I-beam indicates where Excel will insert the selected cells when you release the
mouse button. The I-beam appears whenever the pointer rests on a horizontal or vertical
cell border. In this case, the I-beam indicates the horizontal border between rows 8 and
9, but we could just as easily insert the cells vertically (which would produce unwanted
results). You’ll see the I-beam insertion point lip between horizontal and vertical as you
move the pointer around the worksheet. To insert the cells, release the mouse button while
still pressing the Shift key. When you release the mouse button, the selected cells move to
the new location, as shown in the second image in Figure 8-8.
For information about using the keyboard for this task, see “Inserting copied or cut cells”
later in this chapter.
If you press Ctrl+Shift while dragging, the selected cells are both copied and inserted
instead of moved. Again, a small plus sign appears next to the pointer, and Excel inserts
a copy of the selected cells in the new location, leaving the original selected cells intact.