If you want to learn how to move columns in Excel, then we’ve got you covered right here with two methods.
Microsoft Excel is a great software, but it can be a bit difficult for those who are new to it. This is because most of Excel’s functions are hidden behind layers of options, and even the basic ones aren’t as basic as they sound. For instance, many new Excel users often get confused about how to move a column.
If you’re one of them, then our guide is here to walk you through the entire process. So, without wasting another second, let’s dive in!
How to move columns in Excel by dragging
If you want to move a column in Excel, then follow these steps. The process is pretty straightforward and will hardly take you a few seconds.
Step
Highlight the column
First, highlight the column that needs to be moved by clicking the header containing the relevant letter or number.
Step
Click and drag
Next, move the cursor to the top-right of the column or row until it turns into a black crosshair.
Now, hold shift, left-click and drag the row or column line to the desired location as shown below.
Step
Release
Release the click to complete moving the column to the desired location, and that’s it.
How to move columns in Excel using cut and paste
Alternatively, you can move a column by cutting and pasting it.
Step
Select the column
First, select the column which you wish to move.
Step
Copy and paste it
Next, with the column highlighted, press CTRL + X on your keyboard to cut it. Then, select a new column where you want the previous one to move. Once done, press CTRL + V and the column will be pasted.
Conclusion
Learning how to move a column in Excel can help you organize your data quickly. In this guide, we have explained two methods for the task, and both do a great job. In case you accidentally move the column to the wrong spot, simply press CTRL + Z on your keyboard to undo it.
If you want to learn more about Excel, give these guides a read:
