If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.

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.

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.

However, rows that are filtered out are always excluded, and the SUBTOTAL function doesn't work if there are errors in the data, unless you nest it within the IFERROR function.

Quick Steps to Ungroup Rows in Excel. Microsoft Excel allows you to group sets of rows or columns to save space on your spreadsheets. Removing unnecessary data also makes them easier to read ...

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.