How to insert multiple rows in Excel. 1. Select the row below where you want the new rows to appear. 2. Right-click on the highlighted row, and then click Insert in the context menu.

You can select multiple rows and enter the formula you want to apply to them one time. This will let you compute the data you want out of your Excel spreadsheet. Open an Excel spreadsheet.

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.