For example, if you want to insert a row between the 7 th & 8 th row, select the 8 th row and do right-click, a drop-down list will open. Where you want to insert a new row, select the whole row below of that point.You can download this Insert Multiple Rows Excel Template here – Insert Multiple Rows Excel Template Example #1 – Insert a Single row using a mouseįor inserting a single row using a mouse shortcut, follow the below steps: