Copying Selected Records to a Spreadsheet
You can copy a single record or a subset of records from a collection
to a spreadsheet.
These steps assumes that the form is open and showing the collection
you want to copy from.
NOTE: Carriage returns and line feeds
in a multi-line cell are removed when you copy a row to the clipboard.
So, if you have multi-line cells, you must copy those cells separately
or reconstruct them in the spreadsheet.
To copy a single record to a spreadsheet:
- Click in the left-most column for the record you want to copy.
This action selects and highlights the entire record.
- Press CTRL+C, or select Edit > Copy. This action copies
the record to the system clipboard.
- In your spreadsheet application, select the cell you want to be
the first (left-most) cell of the pasted record.
- Press CTRL+V or use the command your spreadsheet program uses to
paste in the material.
To copy a subset of records from a collection to a spreadsheet:
- Click in the left-most column for the first record you want to
copy.
- Shift-click in left-most column for the last record you want to
copy. The subset of records is highlighted and selected.
You can also select non-adjacent rows for the subset. To do this,
use CTRL-click to select multiple non-adjacent rows, and then paste
them into the spreadsheet as you would any other contiguous set of
records.
Alternatively, you can select the cells to copy by pressing shift-up,
shift-down, shift-right, and shift-left.
- Press CTRL+C, or select Edit > Copy. This action copies
the selected records to the system clipboard.
- In your spreadsheet application, select the cell you want to be
the first (most upper-left) cell of the pasted records.
- Press CTRL+V or use the command your spreadsheet program uses to
paste in the material.
Related Topics
Copying
Data To/From a Spreadsheet
Copying
Entire Collections to a Spreadsheet
Copying
Selected Cells to a Spreadsheet
Copying
Selected Columns to a Spreadsheet
Pasting
Entire Collections into a Grid from a Spreadsheet
Pasting Selected
Records (Rows) from a Spreadsheet
Pasting
the Contents of a Single Cell from a Spreadsheet