Copying a subset of columns to a spreadsheet

These steps assume that you have the form open and showing the collection you want to copy from.

To copy a subset of columns from a collection to a spreadsheet:

  1. Click in the header row for the first column you want to copy.
  2. Shift-click in header row for the last column you want to copy. The subset of columns is selected and highlighted.

    You cannot select non-adjacent columns for the subset. That is, you can use Ctrl-click to select multiple non-adjacent columns, but when you paste them into the spreadsheet only the first column (or first set of adjacent columns) actually gets pasted into the spreadsheet.

    If you have one or more columns that are not adjacent to other columns you want to copy, you can drag non-adjacent columns to a position adjacent to the other columns you want to copy. Then select the set of columns to be copied, once they are all in a contiguous set.

    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 columns to the system clipboard.
  4. In your spreadsheet application, select the cell you want to be the first (upper-most) cell for the pasted columns.
  5. Press Ctrl+V or use whatever command your spreadsheet program uses to paste in the material.