Insert New Column in Excel

In this blog post we will see how we can insert a new column in an excel sheet. There are various methods available in excel to insert a new column. All these methods are explained one by one: 

1. Right Click
2. Insert Command
3. Ctrl and +

1. Right Click:

This is 1st method with which we can insert a new column by using mouse right click. Just follow below steps:

1. Select the entire column where we want to insert a new column. For example if we want to insert a new column on column D then select entire column D. (In below image we can see column D is selected).

2. Press right click on your mouse. Various options will appear on screen. Now, press left click on “Insert” option.

3. Now we can see new blank column is inserted on column D.

2. Insert Command:

Next method is by using Insert command. This command we can find in Home Tab under cells group.

Below image is for your easy reference.

1. Select the entire column where we want to insert a new column. For example if we want to insert a new column on column D then select entire column D. (In below image we can see column D is selected).

2. Go to Insert command and select “Insert Sheet Columns” option.

3. Now we can see new blank column is inserted on column D.

3. Ctrl and +:

This is the keyboard shortcut available to insert a new column.

1. Select the entire column where we want to insert a new column. For example if we want to insert a new column on column D then select column D. (In below image we can see column D is selected).

2. Now hold “Ctrl” key and press “+” key on your keyboard.

3. Now we can see new blank column is inserted on column D.

You can use any of the above method as per your convenience. If you have any queries on this, you can write down in comment box below.