How to insert rows and columns in excel

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.

2.

Select column A.

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

3. Right click, and then click Insert.

Result:

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.

5.

How to sum a column in excel shortcut

Right click, and then click Insert.

Result:

6. Double click cell D10.

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.

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

Result:

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

9.

For example, select column F.

10. Press CTRL SHIFT +.

Result:

Note: to quickly a

how to add column in excel table

how to enter cell in excel with keyboard