Microsoft Office Tutorials and References
In Depth Information
Doing the Old Drag-and-Drop Thing
Copies, drag-and-drop style
What if you want to copy rather than drag and drop a cell range? Suppose
that you need to start a new table in rows farther down the worksheet, and
you want to copy the cell range with the formatted title and column headings
for the new table. To copy the formatted title range in the sample worksheet,
follow these steps:
1. Select the cell range.
In the case of Figures 4-3 and 4-4, that’s cell range A1:E2.
2. Hold the Ctrl key down while you position the mouse pointer on an
edge of the selection (that is, the expanded cell cursor).
The pointer changes from a thick, shaded cross to an arrowhead with a
+ (plus sign) to the right of it with the drag-and-drop ScreenTip beside
it. The plus sign next to the pointer is your signal that drag and drop will
copy the selection rather than move it.
3. Drag the cell-selection outline to the place where you want the copy to
appear and release the mouse button.
If, when using drag and drop to move or copy cells, you position the outline of
the selection so that it overlaps any part of cells that already contain entries,
Excel displays an alert box that asks whether you want to replace the contents
of the destination cells. To avoid replacing existing entries and to abort the
entire drag-and-drop mission, click the Cancel button in this alert box. To go
ahead and exterminate the little darlings, click OK or press Enter.
Insertions courtesy of drag and drop
Like the Klingons of Star Trek fame, spreadsheets, such as Excel, never take
prisoners. When you place or move a new entry into an occupied cell, the
new entry completely replaces the old as though the old entry never existed
in that cell.
I held down the Shift key just as you said . . .
Drag and drop in Insert mode is one of Excel’s
most finicky features. Sometimes you can do
everything just right and still get the alert box
warning you that Excel is about to replace existing
entries instead of pushing them aside. When you
see this alert box, always click the Cancel button!
Fortunately, you can insert things with the Insert
commands without worrying about which way the
I-beam selection goes (see the “Staying in Step
with Insert” section, later in this chapter).