Now we’re ready to add the multiple grand total rows as follows: 1. Right-click the Grand Total cell at the bottom of the PivotTable. 2. Choose Field Settings. 3. In the resulting dialog, click ...

In this guide, Excel Off The Grid walk you through how to build a total row that adjusts itself as your data changes, using some of Excel’s most powerful functions. From customizing calculations ...

Enter a formula or use the AutoSum feature to total all values in a row in Excel. The AutoSum feature enables you to obtain a total for all values in a row or column at the click of a button.

You can even insert blank rows in between each row you've selected, but this involves a little workaround. So whether you're on PC or Mac, here's how to add multiple rows in Excel.

Stay tuned Excel PivotTables are flexible. The one thing that’s not available is a way to add more grand total rows. In a future article, I’ll show you how to do so.

Highlight the rows. Although you can see only the totals, if you copy them now Excel will include the hidden rows. Press "Ctrl-G" or "F5" on the keyboard to bring up the "Go To" dialog box.