Insert Blank Rows or Columns Every Other Rows/Columns in Excel 365!!
Tags: kutoolsexceltutorial, stepstoinsertblankro, kutools
Published: 2020-10-20 12:15:16

---
title: Insert Blank Rows or Columns Every Other Rows/Columns in Excel 365!!
published: true
date: 2020-10-20 10:17:57 UTC
tags: KutoolsExcelTutorial,StepstoInsertBlankRo,Kutools
canonical_url: https://geekexcel.com/insert-blank-rows-or-columns-every-other-rows-columns-in-excel-365/
---

In this article, you will know the simple steps to **Insert Blank Rows or Columns Every Other Row/Column in Excel Office 365** using **Kutools. ** Let’s get into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## Insert Blank Rows Every Other N<sup>th</sup> Row:

To insert blank rows every other N<sup>th</sup> row in the range, follow the below steps.

- You need to **select a range** where you want to insert blank rows.

![Data range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-24.png)<figcaption id="caption-attachment-16080">Data range</figcaption>

- Go to the **Kutools Tab, select** the **Insert** option, **choose** the **Insert Blank Rows & Columns** from the drop-down list.

![Go to the Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-19.png)<figcaption id="caption-attachment-16081">Go to the Kutools Tab</figcaption>

- It will open the **Insert Blank Rows & Columns Dialog box.**
- In that dialog box, you need to **choose** the **Blank rows** option under the **Insert type** option.
- Then, you need to **enter** the **number** into the **Interval of** and **Rows** box.
- **Click** the **OK** button to get the result.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-17.png)<figcaption id="caption-attachment-16087">Click the OK button</figcaption>

- Now, you can see that the number of specified blank rows have been inserted into the selected range as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-30.png)<figcaption id="caption-attachment-16088">Result</figcaption>

## Steps to Insert Blank Columns Every Other N<sup>th</sup> Column:

You can insert the blank column in the specific range. To do this follow the below steps.

- You need to **select a range** where you want to insert blank columns.

![Data range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-24.png)<figcaption id="caption-attachment-16080">Data range</figcaption>

- Go to the **Kutools Tab, select** the **Insert** option, **choose** the **Insert Blank Rows & Columns** from the drop-down list.

![Go to the Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-19.png)<figcaption id="caption-attachment-16081">Go to the Kutools Tab</figcaption>

- It will open the **Insert Blank Rows & Columns Dialog box.**
- In that dialog box, you need to **choose** the **Blank columns** option under the **Insert type** option.
- Then, you need to **enter** the **number** into the **Interval of** and **Columns** box.
- **Click** the **OK** button to get the result.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/4-10.png)<figcaption id="caption-attachment-16089">Click the OK button</figcaption>

- Now, you can see that the number of specified blank columns has been inserted into the selected range as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-37.png)<figcaption id="caption-attachment-16093">Output</figcaption>

## Wind-Up:

In this article, you can grasp the steps to **Insert Blank Rows or Columns Every Other Row/Column in Excel Office 365** using **Kutools. ** Leave your **feedback** in the comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Duplicate Rows or Columns Based On Cell Value in a Specific Column or Row in Excel?](https://geekexcel.com/how-to-duplicate-rows-or-columns-based-on-cell-value-in-a-specific-column-or-row-in-excel/)
- [How to Select Interval Rows or Columns in Excel Office 365?](https://geekexcel.com/how-to-select-interval-rows-or-columns-in-excel-office-365/)