Excel Group feature allows users to group rows or columns. Ungroup is used to ungroup a range of cells or data that were previously grouped.

Microsoft Excel PivotTables turn data into meaningful information, but it's difficult to add grand total rows. Read on to learn how.

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows.

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor ...

How to Use the Multiple Rows Function in Excel. In addition to listing data, you can also use Excel to manipulate data. For example, you can compute sales, determine inventory or calculate nearly ...

Say I have an Excel worksheet with 100 rows. Each row in column 1 has the name of a manager and each product has 10 employees. I want to use Excel to group those so I can just see 10 rows, and ...

You will definitely need to copy the "group" header info into fields for each row, or else you'll lose that information if you try to sort it.<BR><BR>Are you averse to using/writing a macro? Even ...

How to Calculate a Running Total in Excel Learn to create cumulative sums in Microsoft Excel with these step-by-step instructions and screenshots.

Figure F If you group records in a shared workbook, other collaborators won’t see it. Excel doesn’t save hidden rows or columns or groups with a sheet view.