How to move rows and columns in Excel
When you edit documents on Excel columns and rows it may be during that process that you want to rearrange the order and position of the columns and rows. If you do not know how, you can follow the following method of TipsMake.com .
How to move rows and columns in Excel Picture 1
1. How to move columns in Excel
There are two ways to move columns in Excel, with the first one you can use the mouse to move, this method is suitable when the distance you want to move is not too far. The second way you need to use in combination with the keyboard.
1.1 Method 1
First, you need to highlight the column to be moved by hovering over the position at the top of the column then click on the column name, so the entire column will be highlighted.
How to move rows and columns in Excel Picture 2
Then move the mouse to the side of the highlighted column. You need to put the mouse in the position where the mouse will turn into a four-arrows cross.
How to move rows and columns in Excel Picture 3
Click and hold the mouse to the position where you want to move the column.
The blue border shows the position of the data column to be moved. Release the mouse when the appropriate location is reached.
How to move rows and columns in Excel Picture 4
When you move the data to a new location, the position in the old column will leave a space. Now you just need to clear that space. To delete that column space, you just need to black out the whole column by the method guided above.
Then right-click on the highlighted array and select Delete from the menu that appears.
How to move rows and columns in Excel Picture 5
1.2 Method 2
The second way we can use Excel's Cut and Paste function to be able to move columns of data.
First you need to black out the data column you want to move, doing this similar to the instructions mentioned above.
Next, right-click on the highlighted array, select Cut in the options panel that appears. Or you can also use the key combination Ctrl + X to perform the same function.
How to move rows and columns in Excel Picture 6
Next, you highlight the column at the position you want to transfer data to. (Note that if the blacked location you want to move to already has data there, the new column will move to the left of the old data position.)
Right-click on the highlighted array and then select the Insert Cut Cells row in the options panel that appears.
How to move rows and columns in Excel Picture 7
As you will see, the resulting column will be moved to the location you selected.
How to move rows and columns in Excel Picture 8
2. How to move rows in Excel
The method of moving rows in Excel is exactly the same as moving columns in Excel. So we also have two ways to move goods.
2.1 Method 1
You highlight the rows to move in Excel by moving to the numbered position on the left edge of the Excel interface. Click on that number.
How to move rows and columns in Excel Picture 9
Move the mouse to the upper or lower edge of the highlighted row. Then the mouse pointer will change to form a cross arrow.
How to move rows and columns in Excel Picture 10
You click and drag it to the position you want to move to. The blue box will display the position of the row you just blacked.
How to move rows and columns in Excel Picture 11
As you move the column leaving an empty row out, you need to highlight the row and right-click on the highlighted array and select Delete to delete the extra blank row.
How to move rows and columns in Excel Picture 12
2.2 Method 2
With the second method you also need to black out the entire row to be moved. Then right-click on the highlighted array and select Cut in the menu that appears. Or you can use the key combination Ctrl + X for the same function.
How to move rows and columns in Excel Picture 13
Then, like the column insertion method, you highlight the rows where you want the data to be transferred. (Note that if the blacked location you want to move to already has data there, the new row will be located above the old data position.)
Right-click on the highlighted array and then select the Insert Cut Cells row in the options panel that appears.
How to move rows and columns in Excel Picture 14
The highlighted product will be delivered to the location you selected.
How to move rows and columns in Excel Picture 15
Thanks to everyone for following our article TipsMake.com about moving rows and moving columns in Excel. Hopefully the article has provided sufficient information necessary for you to successfully implement this trick.
You should read it
- How to convert columns into rows and rows into columns in Excel
- Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells
- MS Excel 2007 - Lesson 10: Modify columns, rows and cells
- How to handle cells, columns, rows in a spreadsheet in Excel
- How to quickly Add and Delete rows and columns in Excel
- How to temporarily hide rows and columns in Excel 2013
- How to add rows and columns in Excel
- How to fix column and header rows in Excel 2016
- Spacing rows and columns in Excel beautifully
- How to fix columns in Excel
- How to convert rows into columns and vice versa in Excel
- How to add columns, delete columns, add rows, delete rows in Word 2007, 2010, 2013, 2016