Copying data from cell to cell

You can use the cut, copy and paste buttons and commands to move data around your spreadsheet.

To move data:

  1. Select the data cells whose contents you want to copy or move.
  2. Click the Cut or Copy button on the toolbar, or choose Cut or Copy from the Edit menu. Choosing Cut removes the data from the cell, while choosing Copy leaves it there.
  3. Click at the starting position of where you want to paste the data, ie the cell which will now be the top left of the range.
  4. Click on the Paste button on the toolbar, or choose Paste from the Edit menu.
  5. The data will appear in the new cells.