In this tutorial, you will learn how to add a column in between other existing columns. For example, you have entered values in columns A, B, C, D, and E.
Now you need another column in the worksheet that is between C and D. So, the existing column D becomes E while a new column D is added with empty values.
Two ways of adding the column for that scenario are explained below.
First way – Add a column by right click
Suppose we have five existing columns as shown below:
We want to add a new column between C and D. This is how you can do this easily.
Select the existing column D and right-click on this. You may also right-click on any cell of column D after selecting the column.
In the popup menu, click on the “Insert” option as shown below:
After you clicked the Insert, a new column should be added with letter D head:
You can see, the new column is D with empty values. The previous column D became E, and E became F.
Second Way of adding the column – In the Ribbon
This method applies to the following MS Excel versions:
- Excel 2007
- Excel 2010
- Excel 2013
- Excel 2016
- Excel 2019
- Excel Online
- Excel for Office 365
For adding a column in these versions of Excel, follow this:
Select the column as we selected D in the above example.
Select Home > Insert > Insert Sheet Columns
The example of removing a column
Just like adding a new column is simple in Excel, removing an existing column is the matter of two clicks. For removing a column, follow these steps.
Suppose we want to remove the existing “Price” column (D) for the demo.
Select the column D and right click any of its cells.
Click on the “Remove” option in the right click menu.
Column D should be removed.
Note: You may also right click on any cell in the D column without selecting the whole column. In that case, Excel will ask to remove “Table Columns” or “Table Rows” in the right click menu as shown below:
Click on the “Table Columns” and the D column should be removed.
Using the main menu example
Just like adding a new column for Excel version 2007 and above, you may use the main menu for removing a column as follows:
- Go to “Home” in the ribbon
- Under the “Cells” group, open the “Delete” menu
- Click on the “Delete Sheet Columns”
The selected column should have been removed.