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.

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.

Repeating Rows in Excel. When your Excel spreadsheet spans several pages, the data is easier to follow when you print the column titles at the top of every page. Instead of manually repeating the ...

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