How to Move a Column in Excel 2013


When you want to learn how to move a column in Excel 2013, it can be for a number of reasons. Maybe you are trying to make it easier to print your spreadsheet by placing important columns of data near each other, or maybe the organization of your spreadsheet is a little confusing.

But it is a rather simple process to put a column in a different location in your spreadsheet, and Excel will even take care of any cell reference updates caused by the move of your data. So if you have a spreadsheet containing a column that you want to move, then simply follow the steps outlined below.

Do you need to put Microsoft Office on another computer? Consider an Office 365 subscription that lets you install the entire office suite on up to five computers.

 

Moving Columns in an Excel 2013 Spreadsheet

The steps outlined below were performed in Microsoft Excel 2013, but will work in previous versions of Microsoft Excel as well.

If you are moving columns that contain a formula, or which are referenced in formulas, then Excel will automatically update the formulas in the column based upon its new location.

 

Step 1: Open the spreadsheet containing the columns that you want to move.

 

Step 2: Click the column letter of the column that you want to move. This will select the entire column, like in the image below.

select the column to move

 

 

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

how to move a column in excel 2013

 

 

Step 4: Select the column before which you want to insert the column that you just cut. For example, I want to place my cut column between the current columns B and C, so I have selected column C.

select the location for the moved column

 

 

Step 5: Right-click the selected column, then click Insert Cut Cells.

select the insert cut cells option

 

 

Your column should now be moved to its’ correct location, as in the image below.

column after it is moved

 

 

Do you dislike the physical appearance of your spreadsheet? Learn how to change the font of entire worksheet in just a few short steps.

birthday t-shirts for boys
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.