![]() ![]() 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. 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 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. 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.
0 Comments
Leave a Reply. |