Exporting groups to separate Excel worksheets

When you export a grouped document to Excel, you may want to place each grouped set of data (or page) of a grouping field in its own worksheet, in the same Excel workbook.

To export a group to separate Excel worksheets

•  

1. Open the document in Design or Editable Mode.

2. If a group has not been defined, group the data. For more information about grouping data, see Grouping records in a document.

3. In the Grouping panel, right-click the grouping item and select Grouping Properties. The Grouping Properties dialog box opens.

4. Select the Sheet break between groups  check box.

5. Click Apply to apply the changes.

Related topics

•  

• Working with sections in documents

• Inserting page breaks between groups

• Resetting page numbers for each group

• Hiding grouping sections in documents