How to Change the Column Order in Excel
By Tricia Goss
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.
Tricia Goss' credits include Fitness Plus, Good News Tucson and Layover Magazine. She is certified in Microsoft application and served as the newsletter editor for OfficeUsers.org. She has also contributed to The Dollar Stretcher, Life Tips and Childcare Magazine.