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

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.

5. Add New Rows to a Table Rows in a table behave a little differently from rows in a regular worksheet. If you need to add a new row to a table, and if the Totals row is not visible, click in the ...

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.

Take advantage of relative cell references to add the same values to two different rows in Excel. Relative cell references create relationships between cells so that values entered in one cell are ...

Rows in an Excel worksheet can be repeated a specified number of times with user-defined functions. The Selection.insert command can be used to insert rows in an Excel sheet and there is no need to ...

Delete enough rows or columns to make room for what you want to insert and then try again. Microsoft Excel can’t insert new cells because it would push non-empty cells off the end of the worksheet ...