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

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

You can hide and unhide rows in Excel by right-clicking, or reveal all hidden rows using the "Format" option in the "Home" tab.

If you cannot insert, add or create new cells in worksheets in Microsoft Excel, remove cell protection and unmerge the Rows to begin with.

A row-by-row formatting rule is as easy to apply as a column-by-column in Microsoft Excel, but you might not get the results you thought you would.

How Do You Create a Header Row & Description Row in an Excel Spreadsheet?. Your Excel 2013 spreadsheets can benefit from page headers and fixed column titles, also called description rows.