The easiest way to add a column is through the insert feature from the ‘Cells’ group in the Ribbon.
Suppose, for this tutorial, we have this data set:
Now, you want to insert a column between columns D (‘Item 3’) and E (‘Item 4’).
The first thing you need to do is click a cell (any cell will do) in Column E.
By default, Excel inserts an element before the selected element.
So if you need to insert a column between Columns D and E, you need to do so while selecting Column E or any of its cells.
Now, make sure you’re currently on the ‘Home’ tab.
Head over to the ‘Cells’ group on the Ribbon.
Click the ‘Insert’ icon and select ‘Insert Sheet Columns’ from the dropdown options.
You’ll immediately see the newly made column between the ‘D’ and former ‘E’ columns.
To add multiple columns using the insert feature, all you need to do is select multiple cells horizontally.
For example, let’s insert 3 columns between columns ‘C’ and ‘D’.
To do so, select cells horizontally that belongs to columns ‘D’, ‘E’, and ‘F’.
Let’s highlight cells ‘D2’, ‘E2’, and ‘F2’.
Finally, do the steps you did earlier in adding a single column:
- Make sure you’re on the ‘Home’ tab
- Click ‘Insert’ from the ‘Cells’ group
- Select ‘Insert Sheet Columns’