How to display multiple subtotal rows in a Microsoft Excel PivotTable Your email has been sent Microsoft Excel PivotTables are a great way to summarize data. They’re easy to create and display ...

Remove subtotals and turn off outlining before you apply Remove Duplicates. If you're new to Microsoft Excel 2007, take time to study the Remove Duplicates feature, as it did not appear in Excel 2003.

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

You can remove duplicates in Excel in a few steps. Duplicates can create problems when you're dealing with data.