1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Insert Columns to Excel Worksheets

How to Insert Additional Columns into an Excel Worksheet

By

Insert Columns into an Excel Worksheet

Insert Columns into an Excel Worksheet

© Ted French

As with all things Microsoft, there is more than one way to to insert columns to an Excel worksheet. These instructions show you how to insert 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.

Insert Columns to an Excel Worksheet

To insert a single column

  1. Right click on the column header above the location where the new column is to be inserted to open the right click context menu.
  2. Choose Insert from the menu.
  3. The new column will be inserted to the left of the selected column.

To insert multiple columns

  1. In the column header, Drag select the number of columns you want inserted into the worksheet.
  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.

©2014 About.com. All rights reserved.