Click "Insert," then click "Insert Sheet Rows" to insert the new rows. You can also right-click the left of a row and click "Insert" to add a new row below it. Advertisement ...

How to add a second subtotal row to a PivotTable in Excel The default PivotTable is useful, but you might need more information. For instance, let’s add a second subtotal row that returns the ...