The easiest way to move or copy a cell or a selection is by simply
dragging the selection to a new location using the
mouse. An alternative way to move and copy cells is to use cut,
copy, and paste operations described in Section 7.2.
Select a cell to move by clicking in it. You can also select
a range of cells as described in Section 6.4.
Click left mouse button on
the border of the selection (anywhere except the autofill
square in the bottom right corner). Use
left mouse button to move cells
or Ctrl+left
mouse button to copy cells.
Drag the selection to the new location.
Release the mouse button.
The selected cells will be copied or moved to the new
location. This will move both cells' content and
formatting. When copying, relative cell references in all
formulas will change as described in Section 6.3; when moving, relative cell
references will remain unchanged.
Same effect as the normal copy operation. It copies the
content (whether number, string, or formula) and the
format. Equivalent to Ctrl+
left mouse button.
Move
Same effect as the normal move operation. It moves the
contents and the format. Equivalent to
left mouse button.
Copy Formats
Copies the formatting of the source cells. This
includes number format, color, font, fill type, etc. Does
not copy the contents.
Copy Values
Copies the values of the source cell to the destination
cell. Formulas are replaced by their values. For example, if
the original cell contained the formula
=A1+5, and cell A1 contained number 7,
then the option Copy Values will
place in the new cell number 7.