How to Change the Column Order in Excel

By Tricia Goss

Excel allows you to select entire columns to move, delete or otherwise modify.
i Images

When you need to rearrange data in an Excel spreadsheet, you can move an entire column -- or even several contiguous columns -- with little more than some cutting and pasting. Unless you know what to do with a column after cutting it, however, moving it to a new section of the worksheet can be confusing. Learning to use options on the Insert tab will help you change the order of columns quickly.

Click the letter on the column heading of the column you want to move to select the entire column. Press and hold the "Shift" key. Click on the column heading for the last column you want to move if you are changing the order of multiple adjacent columns.

Right-click the selection and choose "Cut." Alternatively, click "Cut" in the Clipboard group of the Home tab. A moving dotted line surrounds the area you cut.

Click the column heading of the column to the right of where you want to place the cut column or columns.

Right-click the selected column, and choose "Insert Cut Cells." Alternatively, click the "Insert" drop-down in the Cells group of the Home tab and select "Insert Cut Cells." Excel moves the columns to the location you selected, changing the order of the columns on the worksheet.


Information in this article applies to Excel 2013. It may vary slightly or significantly with other versions or products.

Changing the order of columns on a worksheet will affect formulas containing cells in those columns.