Share this page:

MS Excel 2011 for Mac: Remove subtotals on pivot table rows

This Excel tutorial explains how to remove subtotals from the rows in a pivot table in Excel 2013 (with screenshots and step-by-step instructions).

Question: In Microsoft Excel 2011 for Mac, how do I remove subtotals on a pivot table row?

Answer:Let's look at an example.

In the spreadsheet below, we have subtotals for each OrderID, but we want to remove these.

Microsoft Excel

Right click on the Order ID field in cell A2 and select "Field Settings" from the popup menu.

Microsoft Excel

When the PivotTable Field window appears, select the None option and click on the OK button.

Microsoft Excel

Now when you return to the spreadsheet, the subtotals for each OrderID are no longer visible.

Microsoft Excel