You can see, three new rows are added between 7 and 8 rows. This should add three new rows as shown below: Now press the same shortcut key as for single row: You may also select only a few cells of these rows: Suppose, we want to add three new rows between the existing row number 7 and 8. The example of adding multiple rows by shortcut Note that, if you right click on row number 7 and press the Insert option, it will add a new row between 6 and 7. This should add a new row with number 8 while that row becomes number 9. Adding a row by right click exampleįor adding a new blank row between 7 and 8, right-click on the number 8 or any cell of the row number 8 and click the “ Insert” option.

Rather than selecting the whole row, you may also select a single cell e.g. This should add a new blank row which number should be 8. The target is to add a new row between row number 7 and 8 as shown below:įor adding a single row by shortcut, select the row number 8 and press Ctrl Shift +.

That is, press these keys together for adding a new row.įor showing how adding one or more row works, I have a worksheet that contains a few rows of data. With demos, you can also see the shortcut for adding rows. In this tutorial, I will show you how to add one or multiple rows in Excel.

While working in Excel, you will require adding one or more rows in between the existing rows that contain text or other information.

How to add multiple rows in excel