Copying Entire Collections to a Spreadsheet

You can copy an entire collection of records from the system to a spreadsheet using the steps below, or you can use the To Excel menu option.

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

To copy an entire collection to a spreadsheet:

  1. Click the blank box in the upper-left corner of the grid. This action selects and highlights the entire collection.
  2. Press Ctrl+C or select Edit > Copy. The contents of the collection are copied to the system clipboard.
  3. In your spreadsheet application, select the cell you want to be the first (most upper-left) cell of the collection.

    Typically, this is the first cell in the worksheet.

  4. Press Ctrl+V or use whatever command your spreadsheet program uses to paste in the material.