How to Cut, Copy, Paste and Clear data
You can cut or copy data from your database to the Windows clipboard and you can paste data from the clipboard into your database. The data copied to the clipboard is formatted so that it may be pasted into any "row and column" type application.
Copies data from the selected cells into the clipboard, then clears the cells.
Select the region you wish to cut.
Copies data from the selected cells into the clipboard.
Select the region you wish to copy.
Copies any cell data from the clipboard into the selected region. Existing data in the selected region may be overwritten by the clipboard data.
Paste has different effects depending on the shape of the data in the clipboard, and the shape of the selected location before the paste operation.
The sets of images below demonstrate these effects. The first image shows the cells that were copied. The second image shows the selected area before the paste operation. The third image shows the result of the paste operation.
If a single cell is in the clipboard, it will be pasted into any selected cells.
If a block of cells are in the clipboard, they will be pasted starting at the top left of the selected cells, with the selection expanded to fit the clipboard data.
If a single row of cells are in the clipboard, and a single column of cells are selected, the clipboard data will be pasted into each row starting at the selected column.
If a single column of cells are in the clipboard, and a single row of cells are selected, the clipboard data will be pasted into each column starting at the selected row.
Note: Records may be added to accomodate the pasted cells, but fields (columns) will never be added - instead the pasted data will be truncated.
Select the region you wish to paste the clipboard data into.
Clears the contents of selected cells. Does not remove the cells, rows, or columns.
Select the region you wish to clear