Copying Blocks of Cells to a Spreadsheet

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:

  1. Click in the first (upper-left) cell you want to copy.
  2. 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.

  3. Press Ctrl+Insert. This action copies the selected block of cells to the system clipboard.
  4. In your spreadsheet program, select the cell you want to be the first (most upper-left) cell for the pasted columns.
  5. Press Ctrl+V or use whatever command your spreadsheet program uses to paste in the material.
Related topics