Copying Selected Cells to a Spreadsheet

You can copy a single cell or a block of cells from a collection to a spreadsheet.

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

NOTES:

Row labels are pasted in the spreadsheet as the first column. The labels are for reference only and should not be copied and pasted back into a grid. In the spreadsheet, you can delete the row-label column, unless you want to keep it for reference purposes.
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 cell to a spreadsheet:

Click in the cell you want to copy.
Press CTRL+C, or select Edit > Copy. This action copies the contents of the cell to the system clipboard.
In your spreadsheet application, select the cell where you want to copy the contents.
Press CTRL+V or use the command your spreadsheet program uses to paste in the material.

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.