Finally, in the pop-up menu, click Insertīased on the number of rows that you had selected, blank rows will be inserted, above the first selected row.Then, after you select the number of row that you want to add, right-click on a row button, for one of the selected rows.Secondly, as you drag, a pop-up (highlighted in green below) will show the number of rows currently selected.For example, select rows 4 to 7, if you want to add 4 blank rows above row 4 Firstly, drag over several row buttons, to select the same number of rows that you want to add.You’re not limited to adding one row at a time - you can quickly add multiple rows in Excel by using a mouse shortcut. For example, if you want a blank row added between rows 3 and 4, right-click on the row 4 button.
![how to add multiple rows in excel table how to add multiple rows in excel table](https://cdn.educba.com/academy/wp-content/uploads/2018/12/Insert-multiple-rows-example-2-4.png)
Right-click on the row button, in the row below the point where you want the new row inserted.You can quickly insert a single row in Excel by using a mouse shortcut. Insert a Single Row with a Mouse Shortcut
HOW TO ADD MULTIPLE ROWS IN EXCEL TABLE HOW TO
Recently, I saw this plea on Twitter:Ĭan anyone help pls? can’t work out how to add a LOT of new rows in Excel between existing data, rather than 1 at a time – ? Many thanks!įor that person, and anyone else who needs to know, here’s the solution. Lots of us are self-taught in Excel, and might have missed learning a shortcut or two.
![how to add multiple rows in excel table how to add multiple rows in excel table](https://i.ytimg.com/vi/f7v6c0OeyCw/maxresdefault.jpg)
For example, you probably know how to insert more than one row in Excel, without adding them one at a time. If you’ve used Excel for a while, you have lots of skills that you might assume everyone else shares.