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

We can expand on the Table topic, because if you add a data validation drop-down to the first cell in a Table, Excel will extend the drop-down to each new record.