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.

Excel will insert three rows between the last two rows. This method is quick and easy, but it works differently. Specficially, Excel inserts rows below and to the right of the selected row or ...