How to Move Columns in Excel 2013

When you want to learn how to move columns 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.

How to Move Columns in Excel – Quick Summary

  1. Click the column letter of the column you want to move.
  2. Right-click the column, then choose Cut.
  3. Select the column to the right of where you want the cut column.
  4. Right-click the selected column, then choose Insert Cut Cells.

We continue below with additional information on how to move columns in Excel, including pictures for each of the steps.

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

If you don’t like to right-click to perform actions in Excel, then you can use some keyboard shortcuts instead.

To cut a selected column, simply press Ctrl + X on your keyboard.

To paste the cut column to the left of a selected column, press Ctrl + Shift + =.

You can use a similar method if you want to move multiple columns in Excel. Click and hold on the first column letter that you wish to move, then drag your mouse left or right to select additional columns. You can then use the same method above to insert the cut cells into the desired location.

Alternatively you can click on the first column you wish to move, then hold down the Shift key and click on the last column you wish to move. This will select all of the columns contained within that range.

These same methods can be used to move rows in Excel as well by selecting row numbers instead of column letters in each applicable situation.

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

solveyourtech.com newsletter
vintage t rex t-shirt

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