Copying Selected Columns to a Spreadsheet

You can copy a single column or a subset of columns from a collection to a spreadsheet.

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

NOTE: 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 column to a spreadsheet:

  1. Click in the header row for the column you want to copy. This action selects and highlights the entire column.
  2. Press CTRL+C, or select Edit > Copy. This action copies the contents of the column to the system clipboard.
  3. In your spreadsheet application, select the cell you want to be the top (upper-most) cell of the pasted column.
  4. Press CTRL+V or use the command your spreadsheet program uses to paste in the material.

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.

Related Topics

Copying Data To/From a Spreadsheet

Copying Entire Collections to a Spreadsheet

Copying Selected Cells to a Spreadsheet

Copying Selected Records to a Spreadsheet

Pasting Entire Collections into a Grid from a Spreadsheet

Pasting Selected Records (Rows) from a Spreadsheet

Pasting the Contents of a Single Cell from a Spreadsheet