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.

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.

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.

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.

  • 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.

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.

  • 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.

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.

  • How do I unhide columns in Excel?
  • To unhide any single column in Excel, use the keyboard shortcut Ctrl+Shift+0. (You must select at least one column on either side of a hidden column or columns to unhide them.) You can also go to the Home tab > Cells group, select Format > Visibility > Hide & Unhide, and then select Unhide Columns.
  • How do I add columns in Excel?
  • To add columns in Excel, right-click the top of the column and select Insert. You can also go to the Home tab > Cells group and select Insert > Insert Sheet Columns.
  • How do I combine two columns in Excel?
  • To combine two columns in Excel, insert a new column near the two columns (A2 and B2 in this example) you want to combine. Select the first cell below the heading of the new column (C2) and enter =CONCATENATE(A2," “,B2) into the formula bar. This combines the data in cell A2 with the data in cell B2, with a space between them.

To unhide any single column in Excel, use the keyboard shortcut Ctrl+Shift+0. (You must select at least one column on either side of a hidden column or columns to unhide them.) You can also go to the Home tab > Cells group, select Format > Visibility > Hide & Unhide, and then select Unhide Columns.

To add columns in Excel, right-click the top of the column and select Insert. You can also go to the Home tab > Cells group and select Insert > Insert Sheet Columns.

To combine two columns in Excel, insert a new column near the two columns (A2 and B2 in this example) you want to combine. Select the first cell below the heading of the new column (C2) and enter =CONCATENATE(A2,” “,B2) into the formula bar. This combines the data in cell A2 with the data in cell B2, with a space between them.

Get the Latest Tech News Delivered Every Day