How to use a conditional format to highlight subtotal rows in Excel Your email has been sent If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting ...

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.

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 without affecting any of your formulas. You can ...

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.

Then click on the AutoSum button in the Home ribbon, and your totals for the rows and columns will appear. See below for a screenshot showing you what to select and where the AutoSum button is located ...