Move Columns Using Your Mouse
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.
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.
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.
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.
Move Columns 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.
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.
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.
