5 Methods to Insert New Columns in Excel (together with Shortcut & VBA)

Including or eradicating columns in Excel in a standard activity whenever you’re working with knowledge in Excel.

And similar to each different factor in Excel, there are a number of methods to insert columns as nicely. You possibly can insert a number of single columns (to the proper/left of a specific one), a number of columns (adjoining or non-adjacent), or a column after each different column in a dataset.


Every of those conditions would want a unique technique to insert a column.

Notice: All of the strategies proven on this tutorial can even work in case you wish to insert new rows


Insert New Columns in Excel

On this tutorial, I’ll cowl the next strategies/eventualities to insert new columns in Excel:

Insert one new column (utilizing keyboard shortcut or choices within the ribbon)Add a number of new columnsAdd non-adjacent columns at one goInsert new columns after each different columnInsert a New Column in an Excel Desk

Insert a New Column (Keyboard Shortcut)

Suppose you will have a dataset as proven beneath and also you wish to add a brand new column to the left of column B.

Under is the keyboard shortcut to insert a column in Excel:

Management Shift + (maintain the Management and Shift keys and press the plus key)

Command + I if you happen to’re utilizing Mac

Under are the steps to make use of this keyboard shortcut so as to add a column to the left of the chosen column:

Choose a cell within the column to the left of which you wish to add a brand new columnUse the keyboard shortcut Management Shift +Within the Insert dialog field that opens, click on the Total Column choice (or hit the C key)Check-the-Entire-Column-option 5 Methods to Insert New Columns in Excel (together with Shortcut & VBA)Check-the-Entire-Column-option 5 Methods to Insert New Columns in Excel (together with Shortcut & VBA)Click on OK (or hit the Enter key).

The above steps would immediately add a brand new column to the left of the chosen column.

One other means so as to add a brand new column is to first choose a whole column after which use the above steps. When you choose a whole column, utilizing the Management Shift + shortcut won’t present the insert dialog field.

It should simply add the brand new column straight away.

Under is the keyboard shortcut to pick out your entire column (as soon as you choose a cell within the column):

Management + Spacebar (maintain the Management key and press the area bar key)

Upon getting the column chosen, you should utilize Management Shift + so as to add a brand new column.

For those who’re not a fan of keyboard shortcuts, you may also use the right-click technique to insert a brand new column. Merely right-click on any cell in a column, right-click after which click on on Insert. This may open the Insert dialog field the place you possibly can choose ‘Total Column’.

Right-click-and-then-click-on-Insert 5 Methods to Insert New Columns in Excel (together with Shortcut & VBA)

Right-click-and-then-click-on-Insert 5 Methods to Insert New Columns in Excel (together with Shortcut & VBA)

This could insert a column to the left of the column the place you chose the cell.

Add A number of New Columns (Adjoining)

In case it’s essential to insert a number of adjoining columns, you possibly can both insert one column and time and simply repeat the identical course of (you should utilize the F4 key to repeat the final motion), or you possibly can insert all these columns at one go.

Suppose you will have a dataset as proven beneath and also you wish to add two columns to the left of column B.

Under are the steps to do that:

Choose two columns (beginning with the one on the left of which you wish to insert the columns)Proper-click wherever within the selectionClick on Insert

To-insert-multiple-columns-right-click-and-then-click-on-Insert 5 Methods to Insert New Columns in Excel (together with Shortcut & VBA)

To-insert-multiple-columns-right-click-and-then-click-on-Insert 5 Methods to Insert New Columns in Excel (together with Shortcut & VBA)

The above steps would immediately insert two columns to the left of Column B.

In case you wish to insert another variety of columns (say three or four or  5 columns), you choose that many to start with.

Add A number of New Columns (Non-Adjoining)

The above instance is fast and quick whenever you wish to add new adjoining columns (i.e., a block of three adjoining columns as proven above).

However what if you wish to insert columns however these are non-adjacent.

For instance, suppose you will have a dataset as proven beneath, and also you wish to insert one column earlier than Column B and one earlier than Column D.

Dataset-to-insert-mulitple-columns 5 Methods to Insert New Columns in Excel (together with Shortcut & VBA)

Dataset-to-insert-mulitple-columns 5 Methods to Insert New Columns in Excel (together with Shortcut & VBA)

Whilst you can select to do that one after the other, there’s a higher means.

Under are the steps so as to add a number of non-adjacent columns in Excel:

Choose the columns the place you wish to insert a brand new column.Proper-click wherever within the selectionClick on Insert.

Select-non-contiguous-columns-and-then-click-on-Insert-columns 5 Methods to Insert New Columns in Excel (together with Shortcut & VBA)

Select-non-contiguous-columns-and-then-click-on-Insert-columns 5 Methods to Insert New Columns in Excel (together with Shortcut & VBA)

The above steps would immediately insert a column to the left of the chosen columns.

Inserted-two-columns-at-one-go 5 Methods to Insert New Columns in Excel (together with Shortcut & VBA)

Inserted-two-columns-at-one-go 5 Methods to Insert New Columns in Excel (together with Shortcut & VBA)

Insert New Columns After Each Different Column (Utilizing VBA)

Typically, you could wish to add a brand new column after each different column in your present dataset.

Whereas you are able to do this manually, if you happen to’re working with a big dataset, this may take a while.

The sooner means of doing this is able to be to make use of a easy VBA code to easily insert a column after each column in your dataset.

Sub InsertColumn()
‘Code created by Sumit Bansal from TrumpExcel.com

Dim ColCount As Integer
Dim i As Integer

StartCol = Choice.Columns.Depend + Choice.Columns(1).Column
EndCol = Choice.Columns(1).Column

For i = StartCol To EndCol Step -1
Cells(1, i).EntireColumn.Insert
Subsequent i

Finish Sub

The above code will undergo every column within the choice and insert a column to the proper of the chosen columns.

You possibly can add this code to an everyday module after which run this macro from there.

Or, if you need to use this performance recurrently, you may also contemplate including it to Private Macro Workbook after which including it to the Fast Entry Toolbar. This fashion, you’ll all the time have entry to this code and might run it with a single click on.

Notice: The above code additionally works when you will have the information formatted as an Excel desk.

Add a Column in an Excel Desk

If you convert a dataset into an Excel Desk, you lose among the flexibility that you’ve with common knowledge in relation to inserting columns.

For instance, you can’t choose non-contiguous columns and insert columns subsequent to it at one go. You’ll have to do that one after the other.

Suppose you will have an Excel Desk as proven beneath.

To insert a column to the left of column B, choose any cell within the column, right-click, go to the Insert choice and click on on ‘Desk Columns to the left’.

Insert-column-in-Excel-table-Table-column-to-the-left 5 Methods to Insert New Columns in Excel (together with Shortcut & VBA)

Insert-column-in-Excel-table-Table-column-to-the-left 5 Methods to Insert New Columns in Excel (together with Shortcut & VBA)

This may insert a column to the left of the chosen cell.

In case you choose a cell in Column B and one in Column D, you’ll discover that the ‘Desk Columns to the left’ choice is grayed out. On this case, you’ll have to insert columns one after the other solely.

What’s stunning is that this works when you choose non-contiguous rows, however not with columns.

So these are among the strategies you should utilize to insert new columns in Excel. All of the strategies lined on this tutorial can even work if you wish to insert new rows (the VBA code would want some modification although).

Hope you discovered this tutorial helpful!

You may additionally like the next Excel tutorials:

error: Content is protected !!