When you develop worksheets, you’ll probably try to keep similar entries together. For example, if you create a worksheet that lists all of the products you sell, you can group the products by category. In the case of a garden supply store, all of the tools would be together, then the furniture, and then a new category for each type of plant. If you want to hide the rows for one set of products, you can define the rows as a group, and you’ll then have the option to choose which rows you would like displayed. The rows you hide are only gone temporarily. The data hasn’t been deleted, it’s just been moved out of your way while you don’t need it.
Click the Expand button next to the group you want to show.
For information about calculating subtotals for groups of rows, see "Summing with Subtotals and Grand Totals".
3.135.202.203