You can manually insert a blank column between every other column but that is not feasible, especially for a large dataset. Also, it will be very time-consuming too. Excel offers some exclusive ways to do it quickly and smartly. So this article will provide you with **3** quick methods to **insert a column** between **every other column** in Excel.

**Table of Contents**hide

**Download Practice Workbook**

You can download the free Excel template from here and practice on your own.

**3 Ways to Insert a Column Between Every Other Column in Excel**

To demonstrate the methods, we’ll use the following dataset that represents some fruits’ **prices **for three consecutive **months**.

**1. Use Keyboard Shortcut to Insert a Blank Column Between Every Other Column in Excel**

In our very first method, we’ll use a **keyboard shortcut** to **insert a column** between every other column in excel. And it’s one of the easiest ways.

**Steps:**

**Select**all the**columns**excluding the**first column**by clicking the**column letter**with pressing and holding**CTRL-key**.- Then just
**press**simultaneously**CTRL + SHIFT + Plus Key(+)**.

Soon after, you will see that Excel has **added a column** between **every other column**.

**Read More: Shortcuts to Insert Column in Excel (4 Easiest Ways)**

**2. Using Helper Row And Sort Feature to Insert a Blank Column Between Every Other Column **

Now we’ll apply a tricky way to do the task. We will need a **helper row** for that and then we’ll use the **Sort command**. Let’s see how to do it.

**Steps:**

**Insert**a new**row**just right**above**the dataset.- Then serially
**type 1**and**2**. - Next, use
**the Flash Fill tool**to**extend**the serial number till the**last column**.

Giving numbers in the **added row** is done.

- After that,
**copy**all the numbered**cells**and**paste**them right after the**last number**in the same row.

- Now,
**select**the whole**dataset**. - Then
**click**as follows:**Home ➤ Editing ➤ Sort & Filter ➤ Custom Sort.**

A **dialog box** will open up soon.

- Click
**Options**.

- Later, mark
**Sort left to right**and press**OK**.

- Then
**click**on the**drop-down**icon from the**Sort by**box and**select**the**row number**of the added row. I selected**Row 4**. - Finally, just
**press OK**.

Now have a look, we are done with the task.

- Lastly,
**delete**the**added row**.

**Read More: Insert Column with Name in Excel VBA (5 Examples)**

**Similar Readings**

**How to Insert Column without Affecting Formulas in Excel (2 Ways)****Excel Fix: Insert Column Option Greyed out (9 Solutions)**

**3. Embed VBA Macros to Insert a Blank Column Between Every Other Column in Excel**

If you like to work with codes in Excel then you can easily **insert a column** between **every other column** in Excel using **VBA macros**.

**Steps:**

- Press
**ALT + F11**to open the**VBA window**. - Then
**click**serially:**Insert ➤ Module.**

**Write**the following**codes**in the module-

```
Sub Insert_Column_Between_Every_Other()
For Xcol = 3 To 8 Step 2
Columns(Xcol).Insert Shift:=xlToRight
Next
End Sub
```

- Then just
**click**the**Run icon**to run the**codes**.

**Code Breakdown**

- First, I created a
**Sub**procedure*Insert_Column_Between_Every_Other*. - Then used a
**For loop**to identify the adding column number starting from**column number 3**and it will skip**2**steps each time the**loop executes.** - Finally, used
**Columns(Xcol).Insert Shift:=xlToRight**to**insert columns**in the**right**positions.

Here’s the output.

**Read More: How to Insert Column with Excel VBA (4 Ways)**

**Practice Section**

You will get a practice sheet in the Excel file given above to practice the explained ways.

**Conclusion**

I hope the procedures described above will be good enough to insert a column between every other column in Excel. Feel free to ask any question in the comment section and please give me feedback.