Excel Help - How to Insert Multiple Rows or Columns in Excel 2013
In this video you’ll learn how to insert multiple rows and columns at the same time. Normally, you would insert a single row by clicking on a cell in the row above which you would like to insert the new row, right-clicking, selecting Insert and clicking on Insert Cells. However, if you need to add more than one blank row or column to your spreadsheet, you may find it very time-consuming to add them one by one. Luckily, there is a much quicker way to do this.
To insert several blank rows or columns, simply highlight the same number of preexisting rows or columns already in your spreadsheet.
Right-click the cells and click Insert.
In the Insert dialog box, click the direction in which you want to shift the surrounding cells.
A new set of blank rows corresponding to the number of preexisting rows you selected will appear.