How to Move a Column in Microsoft Excel

By Anne Hirsh

Microsoft Excel offers multiple ways to accomplish many common spreadsheet tasks. Different versions of Excel vary in their menu and toolbar options for manipulating your data, but all modern versions of Excel use common click and keystroke methods. Whether you are using Excel 2003, 2007 or 2010, you can easily move a column from one portion of your worksheet to another, or even to an entirely different worksheet or workbook. Note that moving columns may alter formulas in other columns that use the moved column as a reference point, so save your data before the move and check your formulas afterward to ensure data accuracy.

Step 1

Open the Excel workbook to the worksheet containing the column you want to move. If you are moving it to a different workbook, open the second workbook to the target worksheet as well.

Step 2

Click in the column header for the column you want to move. Use the built-in Excel column header with the pre-assigned letter, not a user-entered column header. Clicking the built-in header will select the entire column.

Step 3

Press the "Ctrl" and "X" keys simultaneously to cut the column from its original location.

Step 4

Click the column header to the right of where you want the column inserted, whether it is in the same worksheet or elsewhere. This will highlight the column you just clicked.

Step 5

Press "Ctrl" and "V" simultaneously. This will paste the column to the left of your highlighted area, moving it to your target location.