totn Excel 2007 Basics

MS Excel 2007: Insert a new column

This Excel tutorial explains how to insert a column in Excel 2007 (with screenshots and step-by-step instructions).

Question: How do I insert a new column in Microsoft Excel 2007?

Answer: Select a cell to the right of where you wish to insert the new column. In this example, we've selected cell B1 because we want to insert a new column between column A and column B.

Microsoft Excel

Right-click and select "Insert" from the popup menu.

Microsoft Excel

When the Insert window appears, click on the "Entire column" selection and click on the OK button.

Microsoft Excel

A new column should now be inserted in the spreadsheet. In this example, we've inserted a new column into column B. All of the columns to the right of column B will be shifted to the right.

Microsoft Excel