Add Column to the Right of Existing in Excel

When working with Excel, you often need to expand your dataset by adding new columns next to existing ones. For example, inserting "Bonus" and "Tax" column to the right of the "Salary" column.

However, Excel does not provide a direct "insert to the right" option. By default, new columns are always inserted to the left of the selected column. This can be inconvenient when you specifically need to add columns to the right of existing data, especially when working with multiple columns.

In this guide, we'll explore practical ways to add columns to the right of existing columns in Excel. We'll start with a VBA solution, and then introduce a much simpler and more efficient method using Kutools for Excel.

• Add Columns to the Right Using VBA
• Add Columns to the Right Instantly with Kutools for Excel

VBA Code to Insert Columns to the Right of Selection

Since Excel does not offer a built-in feature to directly insert columns to the right of a selection, VBA provides a flexible workaround. With a short macro, you can quickly insert columns to the right of your selected columns.

For example, in the following table, you may want to add new columns such as Bonus and Tax to the right of the Salary column. Follow the steps below to complete this task.

Step 1: Open the VBA Editor

Press Alt + F11 to open the Visual Basic for Applications (VBA) editor.

Step 2: Insert a Module

In the VBA editor, click Insert > Module, then copy and paste the following code into the module window:

VBA Code to insert columns to the right of selection

Sub InsertColumnsToRight()
'Updated by Extendoffice 20260323
    ' Prompt user to select a range
    Dim rng As Range
    Set rng = Application.InputBox("Select columns:", "Kutools for Excel", Selection.Address, Type:=8) 
    If rng Is Nothing Then Exit Sub
    Dim colCount As Long
    colCount = rng.Columns.Count
    ' Insert columns to the right of the selection
    rng.Columns(rng.Columns.Count).Offset(0, 1).Resize(, colCount).EntireColumn.Insert
End Sub

Step 3: Run the Code

1. Press F5 to run the macro.
2. In the pop-up dialog, select the same number of columns as you want to insert.
   For example, to insert two columns to the right of the Salary column, select the Salary column and one column to its left.
3. Click OK.

   

Result

Excel will insert the same number of columns to the right of your selected columns automatically.

While VBA is powerful and flexible, it requires some technical knowledge and is not always convenient for everyday users.

Add Columns to the Right Instantly with Kutools for Excel

If you prefer a faster and more user-friendly solution, Kutools for Excel provides a one-click feature that allows you to insert columns directly to the right—without any coding. The operation is also fully consistent with Excel's native insert behavior. You simply right-click the selected column headers, just like in Excel, making it easy to use without any learning curve.

Step 1: Select the Columns

Select the number of columns where you want to insert new columns to the right.

In this case, I want to insert two columns to the right of the Salary column, so I select the Salary column and one column to its left.

Step 2: Apply the "Add to Right" feature

Right-click on the selected column header. From the context menu, click Add to Right.

Result

Kutools will instantly insert the same number of columns to the right of your selection.

The advantages of using Kutools for Excel

• Directly inserts columns to the right (no workaround needed)
• Automatically matches the number of selected columns
• No VBA or formulas required
• Simple right-click operation, perfect for daily use

This method is especially useful when working with large datasets or when you frequently need to adjust column structures.

Conclusion

Adding columns to the right of existing columns in Excel is a common task, but Excel’s default behavior can make it less straightforward than expected.

• The VBA method provides a customizable solution and works well for users comfortable with macros.
• The Kutools for Excel method offers the most efficient and intuitive approach, allowing you to complete the task in just a few clicks.

If you regularly need to insert columns to the right, using Kutools can significantly streamline your workflow and save time.