Yes, there is a Grouping featu
- Select the rows (or columns) that you want to be able to expand/contract
- Data - Group and Outline - Group
The Subtotals feature is useful when you have data you want to summarize by some category (e.g. sales by state). To use this, you first sort your data by the categories you want to summarize, and then do data-subtotals. When you have subtotals, you can also contract/expand the detail so that only the subtotals are visible.
If you need more info, add detail or e-mail.
Cheers.
Last edited by Razorback64 : August 11th 10 at 01:32 PM
|