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.

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.

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

While creating data in an Excel spreadsheet, there might be cases when you need to highlight the rows with dates less than a specific date.