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.

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

How to Include All Rows for Filters in Excel. Microsoft Excel helps you sort your data for analysis by providing a Filter command. For example, when you want to sort number values from low to high ...

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 ...

Spreadsheet applications like Excel enable you to insert, delete or rearrange entire rows of business data in ways that are difficult or messy to do with old-fashioned pencil and paper ledgers ...

You can insert blanks rows above or below another in Excel, and you can even add them between each row that has data.