Home » Kutools » Insert Blank Rows/Columns Every Other In Excel
AV Voice Changer Software Diamond 9.0
#EXCEL

Insert Blank Rows/Columns Every Other In Excel

It is easy to insert one blank row or column in Microsoft Excel at a time. However, it will not be easy to insert multiple blank rows or columns, and it may be harder to insert multiple rows or columns alternately. But the Insert Blank Rows & Column tool of Kutools for Excel can help you insert multiple rows or columns at specific interval quickly.

Click Kutools > Insert > Insert Blank Rows & Columns. See Screenshots:

Insert Blank Rows & Columns

Insert Blank Rows Every Other (Nth) Rows

Supposing you have a range which you want to insert blank rows every other rows, you can quickly deal with it with following steps:

1. Select the range that you want to insert blank rows.

2. Apply this utility by clicking Kutools > Insert Insert Blank Rows & Columns.

3. In the Insert Blank Rows & Columns dialog box, select Blank rows from Insert type, and enter the numbers into Interval of and Rows box that you need. See screenshot:

select Blank rows from Insert type

4. Then click OK. One blank row has been inserted into at one interval. See screenshots:

How to quickly insert blank column FROM EVERY OTHER

Insert Blank Columns Every Other (Nth) Columns

Supposing you have a range of data, and you need to alternately insert 2 blank columns every other 2 columns. You can do it as this:

1. Highlight the range that you want to insert blank columns.

2. In the Insert Blank Rows & Columns dialog box, check Blank columns from Insert type, and specify the numbers (2) into Interval of and Columns box that you need. See screenshot:

Kutools Insert Blank Rows & Columns dialog boX

3. Then click OK. And every two columns at two intervals have been inserted into the range. see screenshots:

Insert a Blank Row after Every Row in Excel (or Every Nth Row)
Kutools for Excel coupon code.

>>Get the discount of This Amazing Kutools HERE

Check Also

How to Change the Background of a Picture

4 Simple Ways to Change the Background of a Picture

There are several ways to remove or add background to a photo. Follow the instructions …

Soft UI Design System is ready to help you create stunning websites and webapps.

Soft UI Design System PRO – Designed for those who like bold elements

Soft UI Design System PRO is a premium Bootstrap 5 UI Kit that is built …