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:
- Select the data cells whose contents you want to copy.
-
Click the Copy button on the toolbar, or choose Copy from the Edit menu.
- 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.
-
Click on the Paste button on the toolbar, or choose Paste from the Edit menu.
- A copy of the data will appear in the new cells.
To move data:
- Select the data cells whose contents you want to move.
-
Click the Cut button on the toolbar, or choose Cut from the Edit menu.
- 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.
-
Click on the Paste button on the toolbar, or choose Paste from the Edit menu.
- The data will be removed from the old cells and will appear in the new cells.