Home > Microsoft Office > Microsoft Office How To

How to move columns in Excel – 2 simple ways

Change a spreadsheet at a moments notice with this handy guide.
Christian Wait
Last Updated on

Reviewed By: Kevin Pocock

How to move columns in Excel – 2 simple ways
PC Guide is reader-supported. When you buy through links on our site, we may earn an affiliate commission. Read More

Table of Contents

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.

Amazon's Spring Sale is now live!

Amazon's Spring Sale features deals on everything from the latest CPUs to high-powered gaming monitors.

*Stock availability and pricing subject to change depending on retailer or outlet.

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

1

Highlight the column

First, highlight the column that needs to be moved by clicking the header containing the relevant letter or number.

Spreadsheet showing a table with columns labeled model, kan, jenny, kiver, won, ivy, and cassie, illustrating how to move columns in Excel and filled with numerical values under each name.
Column highlighted

Step

2

Click and drag

Next, move the cursor to the top-right of the column or row until it turns into a black crosshair.

Cursor pointing at a number 21.7 on a digital Excel screen with grid lines and numerical values.
Black crosshair

Now, hold shift, left-click and drag the row or column line to the desired location as shown below.

Step

3

Release

Release the click to complete moving the column to the desired location, and that's it.

A spreadsheet displaying a table with columns labeled from a to k, tracking names and numerical data under each name, focused on how to move columns in Excel.
Column moved

How to move columns in Excel using cut and paste

Alternatively, you can move a column by cutting and pasting it.

Step

1

Select the column

First, select the column which you wish to move.

Step

2

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:

About the Author

Christian Wait

Christian 'Reggie' Waits' is a contributor to PC Guide, having written a wide array of how to and buying guide content.