Use these six shortcuts to select Table elements and insert columns and rows quickly in Microsoft Excel, making your use of Tables that much easier.

If you manage data in multiple Excel spreadsheets, you can use the Consolidate Data wizard to merge data from several spreadsheets or workbooks into one master sheet.

You can insert blanks rows above or below another in Excel, and you can even add them between each row that has data.

How to add multiple grand total rows to a PivotTable in Excel When you create a PivotTable, Excel will insert a grand total at the bottom that returns the sum of the value column.