Simple Copy and Move

The easiest way to move or copy a cell or a group of cells is by selecting the cell or cells to be moved or copied, then using the mouse to drag the selection box to a new location.

  1. Select a cell to move by clicking in it. You can also select a range of cells as described in Section 5.6 ― Selecting Cells and Cell Ranges.

  2. 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.

  3. Drag the selection to the new location.

  4. 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 5.2.4.3 ― Cell Referencing; when moving, relative cell references will remain unchanged.