Article After you have consolidated data from multiple worksheets, you may want to change the way that the data is consolidated. For example, you may want to add...
Article To summarize and report results from separate worksheets, you can consolidate data from each separate worksheet into a master worksheet. The worksheets...
Article Calculate subtotals for rows with SUM, AVERAGE, or other function, including nested subtotals, in Excel 2007.
Article In Excel 2007, you can group data and then use an outline to quickly display summary rows or columns, or to reveal the detail data for each group.
Article Remove calculated subtotal rows from a worksheet and remove subtotals from a PivotTable in Excel 2007 and Excel 2010.
Video Learn how to remove calculated subtotal rows from a worksheet in Excel 2010.
