How to Insert a Column in Excel 2010

No matter how much planning you do when you are creating a spreadsheet in Excel 2010, it is very possible that you are going to need to add some information later. But sometimes you may create a spreadsheet that is missing an entire piece of data. At first you might think that your only option would be to copy and paste the data into columns that are one place to the right, but this can be time-consuming and frustrating. Luckily Excel 2010 has a feature that allows you to simple insert a column into an existing spreadsheet.

 

Add a Column in Excel 2010

To be clear, we are talking about inserting a column between other columns that already contain data. You do not need to do anything special if you want to add data to a column after your existing data. With that in mind, follow the steps below to learn how to insert a column into an Excel 2010 spreadsheet.

 

Step 1: Open the spreadsheet into which you want to insert a column.

 

Step 2: Click the letter of the column that is to the right of where you want to insert your column. For example, I want to insert a column between columns C and D, so I have selected column D.

select the column to the right of where you want to insert a column

 

 

Step 3: Right-click the column letter, then click the Insert option.

how to insert a column in excel 2010

 

 

As you can see, I now have a blank column where column D used to be, and my data that was previously in column D has been moved to column E.

example of a column inserted into excel 2010

 

 

 

 

You can also hide columns in Excel 2010. Read this article if you want to learn how to remove a column from view, but you don’t want to delete it.