In case, the methods shown above don’t seem quick enough for you, you can use this method involving some keyboard shortcuts. Use Keyboard Shortcut to Insert Multiple Rows After Every Other Row in Excel Excel Macro to Add Row to the Bottom of a Tableģ.Macro to Insert Row and Copy Formula in Excel (2 Methods).Cannot Insert Row in Excel (Quick 7 Fixes).How to Insert a Row within a Cell in Excel (3 Simple Ways).How to Insert Blank Row After Every nth Row in Excel (2 Easy Methods).Read More: How to Insert Row in Excel ( 5 Methods) ➤ From the options available with the drop-down menu, select Insert Sheet Rows. ➤ Go to the Home > Insert tool in the Excel toolbar under the section called Cells. You can also use the Insert option from the Excel toolbar to add multiple rows within your data set. Run Insert Option from Excel Toolbar to Insert Multiple Rows After Every Other Row in Excel Read More: Macro to Insert Multiple Rows in Excel (6 Methods)Ģ.

You will get the number of blank rows inserted equal to your desired number (3 in this example). ➤ From the options available, select Insert. ➤ Here I have selected three rows because I want to add three blank rows. ➤ Then drag the mouse downward to select the number of rows equal to the number of blank rows you want to include. ➤ Here I have selected the second row because I want to insert rows in front of the second row. ➤ Select the row in front of which you want to enter the blank rows. You can use the Insert option from the Excel toolbar to enter one or more rows within your data set. Run Insert Option from the Context Menu to Insert Multiple Rows After Every Other Row Today our objective is to enter multiple rows within the data set.ġ. Here we’ve got a data set with the Names, Joining Dates and Salaries of some employees of a company called sunflower group. Insert Multiple Rows After Every Other Row.xlsmĤ Quick Ways to Insert Multiple Rows After Every Other Row in Excel

How to add multiple rows in excel