To do so, click Subtotal in the Outline group and then click the Remove All button at the bottom of the resulting dialog box. Unfortunately, you can't use the Subtotal feature with a table.

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.

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