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:
-
Click in the header row for the first column you want to copy.
-
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.
-
Press Ctrl+C, or select . This action copies the selected columns to the system
clipboard.
-
In your spreadsheet application, select the cell you want to be
the first (upper-most) cell for the pasted columns.
-
Press Ctrl+V or use whatever command
your spreadsheet program uses to paste in the material.