Add Columns to Excel Worksheets

How to Add Columns to an Excel Worksheet

As with all things Microsoft, there is more than one way to to add columns to an Excel worksheet. These instructions show you how to add columns by right clicking on the column header.

The column header is the gray bar along the top edge of the worksheet containing the column letters.

Add Columns to an Excel Worksheet

When you add a column, or columns to a worksheet, the columns of data to the right of the insertion point move to the right to make room for the new column(s).

To add more than one column, select more than one column in the column header. For example, if you want to add two columns, select two columns in the column header.

To add a single column

1. Right click on the column header where you want the new column added to open the context menu.
2. Choose Insert from the menu.
3. The new column will be inserted to the left of the selected column.

To add multiple columns

1. In the column header, select the number of columns you want added to the spreadsheet.
2. Right click on the selected columns to open the context menu.
3. Choose Insert from the menu.
4. The new columns will be inserted to the left of the selected columns.