HomeHow to move columns and rows in Microsoft Excel.

How to move columns and rows in Microsoft Excel.

If you want to move a column or row in your spreadsheet to another location, you have several options in Microsoft Excel. We’ll show you what those options are.

To use one of the following methods, first open your spreadsheet with Microsoft Excel on your Windows or Mac computer.

How to move a column in Excel.

To move a column in an Excel spreadsheet, use either drag and drop or cut and paste method.

Related: How do you mimic drag and drop without holding down a mouse button?

Move columns with drag and drop.

With Excel’s drag-and-drop method, you can move your columns just by dragging and dropping.

To use this method, first find the column you want to move to your spreadsheet. At the top of this column, click the column letter so that the entire column is selected.

Select a column in Excel.

Use your mouse or trackpad to move the cursor to the border of the column. This turns your cursor into a four-arrow icon.

Move the cursor to the border of the column in Excel.

While your cursor is a four-arrow icon, hold down the Shift key on your keyboard. Then drag the column to its new location in your spreadsheet. Excel will place your column to the left of the column where you drop it.

Drag columns into Excel.

And this. The column you selected is now available in its new location.

A migrated column in Excel.

Move columns with cut and paste.

Another way to move a column in your spreadsheet is to cut and paste the column.

To use this method, find the column you want to move to your spreadsheet. Right-click on the letter at the top of this column and select “Cut” from the menu.

Right-click on the letter of the column and select. "Cutting" In excel

You will see a dynamic dotted line around your selected column. This confirms that your column has been successfully cut.

A dynamic dotted line around a column in Excel.

Find the column where you want to place your selected column. Excel will place your cut column to the left of this new column. Right-click on the letter in this new column and select “Insert Cut Cells” from the menu.

Right-click and select the letter in the destination column. "Insert the cut cell." In excel

Your original column will appear to the left of the selected column.

One column moved to Excel with cut and paste.

And so you go around your columns in your Excel spreadsheet!

If you have data in one column that you want to split into multiple columns, it’s easy to fix!

Related: How to make a long column into multiple columns in Excel.

How to move a row in Excel.

Like columns, you have a few ways to move rows in your spreadsheets. Use either drag and drop or cut and paste to rotate around your selected rows.

Move a row with drag and drop.

To quickly move a row to a new location, use this drag and drop method.

First, find the queue to move to your spreadsheet. Then click the row number to the far left of your spreadsheet.

Click on the row number in Excel.

Rotate your cursor over the borders of the selected row, and your cursor will turn into a four-arrow icon.

Move the cursor around the border of the row in Excel.

While your cursor is still a four-arrow icon, hold down the Shift key on your keyboard. Then drag the line to its new location.

Drag a line into Excel.

Your queue has now been relocated.

Moved a row in Excel with drag and drop.

Move a row with the cut and paste.

If you do not prefer drag and drop, use the cut and paste method to move your rows.

First, in your spreadsheet, find the queue to move. Then right-click on this row number and select “Cut” from the menu.

Right-click and select the row number. "Cutting" In excel

Now find the row above which you want to place your cut row. Right-click this new row number and select “Insert Cut Cells” from the menu.

Right-click and select the target row number. "Insert the cut cell." In excel

Your queue is now in its new location.

Moved a line with cut and paste in Excel.

And you are ready.

There are times when you want to move your data to your spreadsheets. With Excel’s quick and easy migration options, you can quickly rearrange data in your various spreadsheets. Very useful!


And, if you ever need to convert a row to a column, Excel makes it that much easier.

Related: How to easily convert a row to a column in Excel.