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:

  1. Click in the left-most column for the record you want to copy. This action selects and highlights the entire record.
  2. Press CTRL+C, or select Edit > Copy. This action copies the record to the system clipboard.
  3. In your spreadsheet application, select the cell you want to be the first (left-most) cell of the pasted record.
  4. 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:

  1. Click in the left-most column for the first record you want to copy.
  2. 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.

  3. Press CTRL+C, or select Edit > Copy. This action copies the selected records to the system clipboard.
  4. In your spreadsheet application, select the cell you want to be the first (most upper-left) cell of the pasted records.
  5. 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