Skip to search results
PRODUCT
Office.com results
Insert subtotals in a list of data in a worksheet
Article Calculate subtotals for rows with SUM, AVERAGE, or other function, including nested subtotals, in Excel 2007.
Excel 2007
Remove subtotals
Article Remove calculated subtotal rows from a worksheet and remove subtotals from a PivotTable in Excel 2007 and Excel 2010.
Excel 2010, Excel 2007
Outline (group) data in a worksheet
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.
Excel 2007
Consolidate data in multiple worksheets
Article To summarize and report results from separate worksheets, you can consolidate data from each separate worksheet into a master worksheet. The worksheets can be i...
Excel 2007
Didn't find what you were looking for?Search all of Office.com