Software & Apps MS Office How to Move Columns in Excel Rearrange and swap columns like a real Excel pro by Jerri Ledford Writer, Editor Jerri L. Ledford has been writing about technology since 1994. Her work has appeared in Computerworld, PC Magazine, Information Today, and many others. our editorial process Twitter LinkedIn Jerri Ledford Updated on January 13, 2021 MS Office Excel Word Powerpoint Outlook Tweet Share Email What to Know The easiest way to move a column in Excel is to highlight it, press Shift, and drag it to the new location.You can also use cut & paste or do Data Sort to rearrange columns from the Data tab.Columns that are part of a merged group of cells will not move. This article covers how to move a column in Excel using the mouse, cut and paste a column, and rearrange columns using the Data Sort function. These instructions apply to Microsoft Excel 2019 and 2016 as well as Excel in Office 365. How to Move Columns in Excel There are several ways to rearrange the columns in an Excel worksheet, but one is easier than all the others. It just takes a highlight and a drag-and-drop motion. Here's how to move columns in Excel using your mouse. In the worksheet where you want to rearrange columns, place your cursor over the top of the column you want to move. You should see your cursor change to an arrow. When it does, click to highlight the column. Next, press and hold the Shift key on the keyboard and then click and hold on the right or left border of the column you want to move and drag it to the right or left. As you drag your cursor across the columns, you'll see the borders darken to indicate where the new column will appear. When you're happy with the location, release the mouse click. You column will be moved to the location indicated by the darker border. How to Move a Column in Excel With Cut and Paste The next easiest way to move a column in Excel is to cut and paste the column from the old location to the new. This works much as you would expect it. Highlight the column you want to move, and then press Ctrl + X on your keyboard to cut the column from its current location. You'll see the "marching ants" around the column to indicate it has been cut from its current location. Next, highlight a column to the right of where you want to move the cut column to, and right-click. In the menu, select Insert Cut Cells. The new column is inserted to the left of the selected column. How to Move Columns in Excel Using a Data Sort Moving columns with a data sort is probably not the easiest way to move things around if you only have one or two columns that need to be moved, but if you have a large spreadsheet and you want to change the order of numerous columns, this little trick could be a major time saver. This method will not work if you have Data Validation in place on your existing columns. To proceed, you'll need to remove data validation. To do so, highlight the cells with data validation, select Data Validation > Settings > Clear All, and click OK. To start, you need to add a row to the very top of your spreadsheet. To do this, right-click the first row and select Insert from the context menu. A new row is inserted above your top row. This row must be at the top of the page, above all other header rows or rows of information. Go through your spreadsheet and number the columns in the order you want them to appear in the spreadsheet by entering a number in the new top row. Be sure to number every column you're using. Next, select all the data in the spreadsheet that you want to rearrange. Then on the Data tab, in the Sort & Filter group, click Sort. In the Sort dialog box, click Options. In the Sort Options dialog box, click the radio button next to Sort left to right and then click OK. You're returned to the Sort dialog box. In the Sort By drop down menu select Row 1 and then click OK. This should sort your columns according to the numbers you listed in that first row. Now you can right click the first row and select Delete to get rid of it. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Email Address Sign up There was an error. Please try again. You're in! Thanks for signing up. There was an error. Please try again. Thank you for signing up. Tell us why! Other Not enough details Hard to understand Submit