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.
Use your mouse or trackpad to move the cursor to the border of the column. This turns your cursor into a four-arrow icon.
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.
And this. The column you selected is now available in its new location.
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.
You will see a dynamic dotted line around your selected column. This confirms that your column has been successfully cut.
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.
Your original column will appear to the left of the selected column.
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.
Rotate your cursor over the borders of the selected row, and your cursor will turn into a four-arrow icon.
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.
Your queue has now been relocated.
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.
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.
Your queue is now in its new location.
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.