How to Add a Column in Excel

1. First of all, right-click on any cell in the column.
2. Next , you will get a pop-up with various options.
3. After this , click on the “Insert” option.
4. Now, right-click and you will get a pop-up with multiple options.
5. Now, select the “Entire column” option and press ok.
6. Here , the column has been inserted to the left of your selected cell.

Tip: you can select the whole single or various  columns by selecting the column header letters and right-click, then select “Insert” from the pop-up option. The number of inserted columns always depends on how many columns you have selected.

You can also insert the column from the “Home” Tab Ribbon.

1. Firstly, make sure that you are on the “Home Tab” and then click on any cell in the column.
2. Here, you will find the “Insert” icon within the “cells” group on the Ribbon
3. After this, click on the “Insert” icon and select “Insert Sheet Column” from the listed drop-down option .
4. Now , the column has been inserted to the left of your selected column cell.

• To add multiple columns, first of all you need to select different  cells instead of a single cell.
• Then, right-click and you will get a pop-up  with multiple options.
• Now, click on the “Insert” option.
• Once you click on the “Insert” option, you will again get a pop-up option.
• Now, select the “Entire column” option and click ok.
• At this point, three columns have been inserted to the left of your selected cells as you had selected three cells.
• To add the multiple “non-adjacent” columns, First, you need to select the cells one by one by holding the CTRL key from the keyboard.
• Once you select the cells, release the CTRL key
• After that, right-click and click on the “Insert” option from the pop-up options.
• Now, select the “Entire column” option and click ok.
• At this point, “non-adjacent” columns have been inserted to the left of your selected cells.

When you convert your data set into a table range, the insert column method losses some of its functionality.

For example, you cannot insert non-adjacent columns in one go as you do in a normal data set by selecting the non-adjacent columns to insert columns to the left of them.

In table range, if you want to insert multiple non-adjacent columns, you need to do it one by one.

• First, click on any cell in the column and right-click.
• Now, click on the “Insert” option from the pop-up and then select “Table Columns to the Left”.
• At this point, the column has been inserted to the left of your selected cell.
• To insert the adjacent multiple cells, First, you need to select the multiple adjacent columns.
• Now, click on the “Insert” option from the pop-up and then select “Table Columns to the Left”.
• At this point, two columns have been inserted to the left of your selected cells.