Buzz
When editing documents in Excel, you may find yourself wanting to rearrange the order and position of columns and rows. If you're unsure how, follow these steps from SoftwareTips.com.
1. Moving Columns in Excel
There are two ways to move columns in Excel. With the first method, you can use the mouse to move, which is suitable when the distance you want to move is not too far. The second method requires a combination of keyboard shortcuts.
1.1 Method 1
First, you need to select the column you want to move by clicking on the column header. This will highlight the entire column.
Next, move your mouse to the edge of the highlighted column until it turns into a four-headed arrow cursor.
Click and hold the mouse, then drag the column to the desired location.
A green border will indicate where the data column will be moved to. Release the mouse when you reach the appropriate position.
When you move data to a new location, the old column will leave a gap. Now, you just need to delete that gap. To delete the column gap, simply select the entire column using the method explained above.
Then, right-click on the highlighted range and choose Delete from the displayed options menu.
1.2 Method 2
Another method involves using Excel's Cut and Paste feature to move data columns.
First, select the data column you want to move, following the same instructions as mentioned above.
Next, right-click on the selected data range and choose Cut from the displayed options menu. Alternatively, you can use the shortcut Ctrl + X to perform the same function.
Then, select the column at the desired destination for the data transfer. (Note that if the selected destination already contains data, the new column will be placed to the left of the existing data.)
Right-click on the highlighted range and select Insert Cut Cells from the displayed options menu.
As you'll see, the column will be moved to the position you selected.
2. Moving Rows in Excel
The method for moving rows in Excel is similar to moving columns in Excel. Therefore, we also have two ways to move rows.
2.1 Method 1
Select the row you want to move in Excel by navigating to the numbered row on the left edge of the Excel interface. Click on that number.
Move your mouse to the top or bottom edge of the selected row. The mouse cursor will then change to a cross-shaped arrow.
Click and drag it to the desired position. A green boundary box will display the destination where the selected row will move to.
When you move a column, it leaves behind an empty row. You need to select that row, then right-click on the highlighted range and choose Delete to remove the extra row.
2.2 Method 2
With the second method, you also need to select the entire row you want to move. Then, right-click on the selected range and choose Cut from the displayed options menu. Alternatively, you can use the shortcut Ctrl + X for the same function.
Then, similar to inserting a column, select the row at the desired destination for the data transfer. (Note that if the selected destination already contains data, the new row will be placed above the existing data.)
Right-click on the highlighted range and select Insert Cut Cells from the displayed options menu.
The selected row will be moved to the position you chose.
Thank you everyone for following the article by TipsAndTricks.com on how to move rows and columns in Excel. We hope the article has provided all the necessary information for you to successfully perform this trick.
