I would like to insert multiple rows into the middle of an Excel spreadsheet. What is the easiest way to do this?
Inserting multiple rows into the middle of an Excel spreadsheet is not very time consuming, nor difficult. To insert one row, you would simply click Insert → Row. Inserting multiple rows, however, is a little different. Say you would like to insert 5 rows. Using your mouse, highlight 5 existing rows, starting at the position where the first new row should be inserted. Don’t worry about highlighting rows that already contain data — they will not be overwritten. Excel will move them down.
Fig. 1 - Selecting the number of rows you wish to add.
Once you have selected the number of rows you wish to add, click Insert → Rows. Excel will insert as many rows as you have selected, starting at the first row in the selection.
Fig. 2 - Multiple rows inserted into an Excel spreadsheet.
