Copying data from cell to cell

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

To copy data:

  1. Select the data cells whose contents you want to copy.
  2. Click the Copy button on the toolbar, or choose Copy from the Edit menu.
  3. Click at the starting position of where you want to paste the data, i.e. 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. A copy of the data will appear in the new cells.

To move data:

  1. Select the data cells whose contents you want to move.
  2. Click the Cut button on the toolbar, or choose Cut from the Edit menu.
  3. Click at the starting position of where you want to paste the data, i.e. 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 be removed from the old cells and will appear in the new cells.