Add a Column

 

To add a column in Excel, right-click the column letter and click Insert. When you insert a column or row, cell references update automatically.

1. First, select cell A10 below and press ALT + = to quickly sum a column of numbers.

Sum a Column of Numbers

2. Select column A.

Select a Column

Note: new columns will be added to the left of the selection.

3. Right click, and then click Insert.

Click Insert

Result:

Add a Column in Excel

To add multiple columns, execute the following steps.

4. Select multiple columns by clicking and dragging over the column headers. For example, select column A and column B.

Select Multiple Columns

5. Right click, and then click Insert.

Click Insert

Result:

Add Multiple Columns in Excel

6. Double click cell D10.

Cell References Update Automatically

Note: when you insert a column or row, cell references update automatically.

You can also use the Insert option on the Home tab.

7. For example, select column A, B, C and D.

Select Columns

8. On the Home tab, in the Cells group, click Insert, Insert Sheet Columns.

Insert Sheet Columns

Result:

Add Columns in Excel

To quickly add a column, select a column and use the shortcut CTRL SHIFT +.

9. For example, select column F.

Select a Single Column

10. Press CTRL SHIFT +.

Result:

Add a Single Column in Excel

Note: to quickly add multiple columns, select multiple columns and use the same shortcut.