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

How to Insert a Column to the Left in Excel (6 Methods) 

While working in Excel, you might need to insert a new column if you miss it earlier. Certainly, you can accomplish the simple but necessary task within seconds in Excel. In this instructive session, I’ll show you 6 methods including shortcut and VBA code on how to insert a column to the left as well as a bonus method to insert multiple columns in Excel.


Download Practice Workbook


6 Methods to Insert a Column to the Left in Excel

Let’s introduce today’s dataset (B4:D15 cell range) as shown in the following screenshot. Here, the Number of Visits for each website is provided along with the Name and Categories of the Sites. However, I want to add the mode of Platforms to the left of the Number of Visits column.

Dataset

Let’s explore the methods.


1. Using Context Menu

In the beginning method, I’ll discuss how you can utilize the Insert option from the Context Menu. Follow the steps below.

➜ Initially, select any cell within the column Number of Visits. Later, right-click and choose the Insert option from the Context Menu.

Using the Context Menu

➜ Next, you’ll see a dialog box namely Insert. Then, check the circle before the Entire Column option.

Using the Context Menu

After pressing OK, you’ll get a new column to the left of your specified column.

Using the Context Menu

Again, if you enter the data, the newly inserted column will look as follows.

Using the Context Menu

Alternatively, if you want to skip the opening of the Insert dialog box, you may adapt the following way.

➜ Firstly, click on the column letters (e.g. D for the Number of Visits column) to select the entire column.

Using the Context Menu

➜ Now, just choose the Insert option from the Context Menu.

Using the Context Menu

Shortly, you’ll get the new column as shown in the following screenshot.

Using the Context Menu

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


2. Keyboard Shortcut to Insert a Column to Left 

Undoubtedly, the keyboard shortcut is fruitful especially when you have to insert a new column to the left in Excel.

➜ Select a cell within the column and press CTRL + SHIFT + +. Eventually, the Insert dialog box will be opened, and check the circle before the Entire column option.

How to Insert a Column to the Left in Excel Using the Keyboard Shortcut

But if you want to execute the same task fastly, you might press CTRL + Spacebar for selecting the entire column. Then, press CTRL + SHIFT + + to insert a column to the left of the Number of Visits column.

How to Insert a Column to the Left in Excel Using the Keyboard Shortcut

If you adapt any of the above-discussed ways, you’ll get the newly inserted column.

How to Insert a Column to the Left in Excel Using the Keyboard Shortcut

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


3. Utilizing Insert Feature from Ribbon

Furthermore, you can utilize the Insert feature from the Excel ribbon. You have to select a cell within the column exactly and choose the Insert Sheet Columns option from the drop-down list in the Insert option which exists in the Cells ribbon.

How to Insert a Column to the Left in Excel Utilizing the Insert from Ribbon

Eventually, you’ll get the following output.

How to Insert a Column to the Left in Excel Utilizing the Insert from Ribbon

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


Similar Readings


4. Insert a Column to the Left in Excel Table

What if you want to insert a column to the left in the case of an Excel table?

Insert a Column to the Left in Excel Table

To be honest, it is quite a simple task.

➜ Rightly, you need to select a cell within the column and pick the Insert Table Columns to the Left option from the drop-down list in the Insert option.

Insert a Column to the Left in Excel Table

➜ Otherwise, you can also use the Insert option from the Context Menu to accomplish the same task.

However, you’ll get the inserted column (insert data as you prefer) in the table as shown below.

Insert a Column to the Left in Excel Table

Read More: Excel Fix: Insert Column Option Greyed out (9 Solutions)


5. Using VBA Code

Again, if you are accustomed to using the VBA code, you may use it to insert a column directly without picking any options.

Needless to say, you need to create a module to insert the VBA code.

➤ Firstly, open a module by clicking Developer > Visual Basic (keyboard shortcut: ALT + F11).

➤ Secondly, go to Insert > Module.

Then, copy the following code.

Sub Insert_Column()

Columns("D:D").Insert Shift:=xlToLeft

End Sub

How to Insert a Column to the Left in Excel Using the VBA Code

In the above code, I used the Columns property to assign the range of the Number of Visits column. Later, I used the Insert method to insert a new column along with the xlToLeft, a notable End property to locate the new column to the left position.

When you run the code (the keyboard shortcut is F5 or Fn + F5), you’ll get the following filtered dataset.

Using the VBA Code

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


6. Insert Multiple Columns to the Left

The last and sixth method is to insert multiple columns to the left.

Luckily, you can insert multiple columns for adjacent cells and non-adjacent cells. Here, I am showing the process for non-contiguous cells.

Let me clear this thing. I want to insert a column to the left of Categories of the Sites and another column to the left of the Number of Visits column.

➜ Right now, click on the two-column letters (e.g. C and D) holding the CTRL key. Subsequently, choose the Insert option from the Context Menu.

How to Insert a Column to the Left in Excel Insert Multiple Columns to the Left

Finally, you’ll get two inserted columns (after inserting columns I filled them with data) as shown in the following screenshot.

How to Insert a Column to the Left in Excel Insert Multiple Columns to the Left

Read More: Cannot Insert Column in Excel (All Possible Causes with Solutions)


Conclusion

That’s the end of today’s session. So, you might insert a column to the left utilizing the above methods in Excel. Anyway, if you have any queries or recommendations, please share them in the comments section.

Surely don’t forget to share the article with your community!


Related Articles

Md. Abdul Kader

Md. Abdul Kader

Hi! I am Abdul Kader and presently working as ‘Excel & VBA Content Developer’ at Exceldemy. I publish my articles related to Microsoft Excel here. In 2019, I completed my graduation in Urban and Regional Planning from Chittagong University of Engineering and Technology. Having extreme eagerness to learn, I want to develop my skills and capabilities higher.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo