Microsoft Office Tutorials and References
In Depth Information
Doing the Old Drag-and-Drop Thing
Doing the Old Drag-and-Drop Thing
The first editing technique you need to learn is drag and drop . As the name
implies, you can use this technique to pick up a cell selection and drop it into
a new place on the worksheet. Although drag and drop is primarily a
technique for moving cell entries around a worksheet, you can adapt it to copy a
cell selection, as well.
To use drag and drop to move a range of cell entries (one cell range at a
time), follow these steps:
1. Select a cell range.
2. Position the mouse pointer on one edge of the extended cell cursor
that now surrounds the entire cell range.
Your signal that you can start dragging the cell range to its new position
in the worksheet is when the pointer changes to the arrowhead.
3. Drag your selection to its destination.
Drag your selection by depressing and holding down the primary mouse
button — usually the left one — while moving the mouse.
While you drag your selection, you actually move only the outline of
the cell range, and Excel keeps you informed of what the new cell range
address would be (as a kind of drag-and-drop ScreenTip) if you were to
release the mouse button at that location.
Drag the outline until it’s positioned where you want the entries to
appear (as evidenced by the cell range in the drag-and-drop ScreenTip).
4. Release the mouse button or remove your finger or stylus from the
The cell entries within that range reappear in the new location as soon
as you release the mouse button.
In Figures 4-3 and 4-4, I show how you can drag and drop a cell range. In
Figure 4-3, I select the cell range A10:E10 (containing the quarterly totals)
to move it to row 12 to make room for sales figures for two new companies
(Simple Simon Pie Shoppes and Jack Be Nimble Candlesticks, which hadn’t
been acquired when this workbook was first created). In Figure 4-4, you see
the Mother Goose Enterprises – 2013 Sales worksheet right after completing
this move.
Search JabSto ::

Custom Search