Copying a subset of records to a spreadsheet

These steps assumes that the form is open and showing the collection you want to copy from.

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