These steps assume that you have the form open and showing the collection
you want to copy from.
To copy a block of cells from a collection to a spreadsheet:
-
Click in the first (upper-left) cell you want to copy.
-
Shift-click in last (lower-right) cell you want to copy. The block
of cells is selected and highlighted.
You cannot select non-adjacent cells. That is, you can use Ctrl-click to select multiple non-adjacent cells,
but when you paste them into the spreadsheet only the first cell (or
first contiguous block of cells) actually gets pasted into the spreadsheet.
Alternatively, you can select the cells to copy by pressing shift-up,
shift-down, shift-right, and shift-left.
-
Press Ctrl+Insert. This action copies
the selected block of cells to the system clipboard.
-
In your spreadsheet program, select the cell you want to be the
first (most upper-left) cell for the pasted columns.
-
Press Ctrl+V or use whatever command
your spreadsheet program uses to paste in the material.