Microsoft Office Tutorials and References
In Depth Information
Using Drag and Drop to Move or Copy Cells
The Paste button on the Ribbon (Figure 3–13) includes an arrow, which displays
a list of advanced paste options (Paste, Paste Special, and Paste as Hyperlink). These
options will be discussed when they are used.
An alternative to clicking the Paste button is to press the ENTER key. The ENTER
key completes the paste operation, removes the marquee from the source area, and dis-
ables the Paste button so that you cannot paste the copied source area to other destination
areas. The ENTER key was not used in the previous set of steps so that the capabilities of
the Paste Options button could be discussed. The Paste Options button does not appear
on the screen when you use the ENTER key to complete the paste operation.
Move It or Copy It
You may hear someone
say, “Move it or copy it,
it’s all the same.” No, it
is not the same! When
you move a cell, the data
in the original location is
cleared and the format
is reset to the default.
When you copy a cell, the
data and format of the
copy area remain intact.
In short, you should
copy cells to duplicate
entries and move cells to
You also can use the mouse to move or copy cells. First, you select the source area
and point to the border of the cell or range. You know you are pointing to the border of
the cell or range when the mouse pointer changes to a block arrow. To move the selected
cell or cells, drag the selection to the destination area. To copy a selection, hold down the
CTRL key while dragging the selection to the destination area. You know Excel is in copy
mode when a small plus sign appears next to the block arrow mouse pointer. Be sure to
release the mouse button before you release the CTRL key. Using the mouse to move or
copy cells is called drag and drop .
When you cut a cell or
range of cells using the
Cut command or Cut
button, Excel copies
the cells to the Ofﬁ ce
Clipboard, but does not
remove the cells from
the source area until
you paste the cells in
the destination area by
clicking the Paste button
or pressing the ENTER key.
When you complete the
paste, Excel clears the
cell entry and its formats
from the source area.
Another way to move cells is to select them, click the Cut button on the Ribbon
(Figure 3–12 on page EX 175) to remove them from the worksheet and copy them to
the Ofﬁ ce Clipboard, select the destination area, and then click the Paste button on the
Ribbon or press the ENTER key. You also can use the Cut command on the shortcut menu,
instead of the Cut button.
If you want to insert
multiple rows, you have
two choices. First, you
can insert a single row by
using the Insert command
on the shortcut menu
and then repeatedly
press F 4 to keep inserting
rows. Alternatively, you
can select any number
of existing rows before
inserting new rows. For
instance, if you want to
insert ﬁ ve rows, select
ﬁ ve existing rows in the
worksheet, right-click the
rows, and then click Insert
on the shortcut menu.
At any time while the worksheet is on the screen, you can insert cells to enter new data or
delete cells to remove unwanted data. You can insert or delete individual cells; a range of
cells, rows, columns; or entire worksheets.
The Insert command on the shortcut menu allows you to insert rows between rows
that already contain data. According to the sketch of the worksheet in Figure 3–3a on
page EX 166, two rows must be inserted in the What-If Assumptions table, one between
Commission and Marketing for the Margin assumption and another between Research
and Development and Support, General, and Administrative for the Revenue for Bonus
assumption. The following steps accomplish the task of inserting the new rows into the