Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

Shortcuts to Insert Column in Excel (4 Easiest Ways)

We are often required to insert a column to an existing dataset in Excel. This is a really easy task and you can do it in various ways. In this article, I will discuss four ways to insert a column Excel shortcut that will make your tasks more interesting and easy.


Download Practice Workbook

This is the dataset. Here, the Name indicates the name of the salesmen. Each has a unique ID and the amount of sales that they have made is enlisted under the Sales Column.


4 Shortcut Ways to Add a Column in Excel

1. Using Shortcut Keywords to Insert a Column in Excel

You can easily insert a column in your existing dataset as a shortcut. Here, basically, I am going to discuss two shortcuts that you can apply in your Excel datasheet.


1.1 Using SHIFT + CTRL + Equal (=) Shortcut 

Suppose you want to add a column left to the “Name” header.
Since “Name” is in column C.
➤ Select Entire column C.

Then press CTRL + SHIFT + Equal (=)
A new column will be added to the left of the header “Name”. The output will be like this

Insert one Column in shortcut


1.2 Using Shortcut ALT + I, C

To add a column to the left of the “Name” column,
➤ Select the entire column C. Because the header “Name” is in column C.

Then,
⇒ Press ALT + I (Do not hold the keys).
⇒ And finally, press C.

A new column will be added to the left of the header “Name”. The output will be like this

Read More: How to Insert Column without Affecting Formulas in Excel (2 Ways)


2. Insert Multiple Adjacent Columns Using Excel Shortcut

I am going to show two ways to insert multiple adjacent columns by using keyboard shortcuts.


2.1. Using Shortcut SHIFT + CTRL + Equal (=)

To add two adjacent columns to the left of column C, select column C, and column D at once by right-clicking and dragging my mouse.
Or you can hold the CTRL key and then select multiple columns.

Then press CTRL + SHIFT + Equal (=)
Thus you will add two adjacent columns next to the “Name” column. The output will be like this.

Insert Column Excel Shortcut multiple Column


2.2. Using Shortcut ALT + I, C

You can also use a keyboard shortcut to insert multiple adjacent columns.
To insert two adjacent columns to the left of the “Name” header, select column C and column D at once by right clicking and dragging my mouse.

Then,
→ Press ALT + I.
→And finally C.

Thus two new columns adjacent to each other will be added to the left of the “Name” column. The output will be like this.

Note:
You must select column C and column D at once by right-clicking and dragging the mouse.


3. Insert Multiple Non Adjacent Columns Using Shortcut

I’m going to show you two cases here too.


3.1. Using Shortcut SHIFT + CTRL + Equal (=)

This time you are going to insert two non-adjacent columns in Excel using shortcuts. To add two columns that will not be adjacent to each other, select column C and column D again.
But this time,
➤ First, select column C.
➢ Then hold the CTRL Key and select column D.

Then press CTRL + SHIFT + Equal (=)
This time, two new columns will appear, but they will not be adjacent to each other. One will be to the left of the header “Name” and another one to the left of the “Sales” header.
The output will be like this.

How to insert column in Excel in Shortcut


3.2. Using Shortcut ALT+I, C

To apply this shortcut and add multiple non-adjacent columns,
➤ First select column C.
➢ Then hold CTRL Key.
➤ And finally select column D.

Then,
⇒Press ALT + I.
⇒And finally, press C.

This time, two new columns will appear, but they will not be adjacent to each other. One will be to the left of the header “Name” and another one to the left of the “Sales” header.
The output will be like this.

How to insert column in Excel in Shortcut

Note:

You must first select column C.
Then press CTRL Key.
And then select column D.

Read Name: How to Insert a Column Between Every Other Column in Excel (3 Methods)


4. Insert Column Using VBA

Now I am going to show how to insert a new column using VBA. To insert a column to the left of Column C,
Go to Developer tab >> select Visual Basic

Insert Column using VBA

A new window will appear.
Then from Insert tab >> select Module

 

After that, write the following code in the Module.

Sub Shortcut_to_Insert_Column()
Range("D3").EntireColumn.Insert
End Sub

Here,
⇒ In the Sub Shortcut_to_Insert_Column, I have used the “Entire Column” property and “Insert” method.
➤ And I have used C2 to refer to the whole Column C.
To run the program from the Run tab >> select Run Sub/UserForm

 

Insert Column in Excel in Shortcut

As a result, a new column will be added to the left of the Name header.

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


Practice Workbook

Practice is indeed the single most important factor to get used to these shortcut methods. So, I have attached a practice workbook where you can practice inserting a new column using these shortcuts.

Insert Column Excel Shortcut


Conclusion

I tried to explain 4 ways to insert a column Excel shortcut. These different shortcut ways will definitely help you add new columns in Excel. And lastly, if you have any kind of suggestions, ideas, or feedback please feel free to comment down below.


Related Articles

Akib

Akib

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

2 Comments
  1. Very useful.

  2. Extraordinary! Brilliant

Leave a reply

ExcelDemy
Logo