Kutools for Excel’s Insert Blank Rows & Columns feature can also insert multiple blank rows or column between every n rows or columns easily in a selection.ġ. Have a Free Trial! Insert multiple blank rows/columns between each row/column The Insert Blank Rows & Columns feature of is handy to insert multiple blank rows/columns between two or every n rows/columns. Then click OK, and 10 blank rows are inserted between the Row 4 and Row 5 at a blink of eyes. Enter 1 in the Interval of box, and enter 10 in Rows box of the Options section. In the Insert Blank Rows & Columns dialog box, choose the Insert type you need. Select the Row 4 and Row 5 in this case, and click Kutools > Insert > Insert Blank Rows & Columns, see screenshot:Ģ. Full feature free trial 30-day, no credit card required! Get It NowĪfter installing Kutools for Excel, please do as below:ġ. Kutools for Excel- Includes more than 300 handy tools for Excel. Is there a way to insert multiple blank rows or columns, without neither accounting and selecting proper amount of rows nor pressing F4 repeatedly? Yes, the Kutools for Excel's Insert Blank Rows & Columns tool can help you deal with it conveniently.
