Home » How to Swap Columns or Rows in Excel

How to Swap Columns or Rows in Excel

We understand that when you are changing the text sequence in Microsoft word, you have to change everything manually because Microsoft word does not give you the feature of swapping the rows or columns for rearranging the text. It can be pretty annoying and time-consuming to rearrange the rows or column data manually on Microsoft word. However, you do not have to go through the same thing with Microsoft Excel as you get a swap function in Excel that you can use to swap columns in Excel. 

When you are working on an Excel sheet, you have the cells filled with some data, but you accidentally put the wrong data for one column or row in another column or row. At that point, the question arises of how to swap columns or rows in Excel? Therefore, to help you figure out Excel’s swap function, we have come with a small guide that you can follow.

How to swap columns or rows in Excel

How to Swap Columns or Rows in Microsoft Excel

Reasons to know how to swap columns or rows in Excel

When you are doing an important assignment for your boss, where you have to insert the correct data in the specific columns or rows in an Excel sheet, you accidentally insert the data of column 1 in Column 2 and the data of row 1 in row 2. So, how do you fix this error because doing it manually is going to take you a lot of time? And this is where the swap function of Microsoft excel comes in handy. With the swap function, you can easily swap any rows or columns without having to do it manually. Therefore, it is important to know how to swap columns or rows in Excel.

We are mentioning a few ways for Swapping columns or rows in Excel. You can easily try any of the following methods for swapping the columns or rows in an Excel worksheet.

Method 1: Swap Column by Dragging

The dragging method requires some practice as it could be more complex than it sounds. Now, let us suppose you have an Excel sheet with different monthly scores for your team members and you want to swap the scores of Column D to column C, then you can follow these steps for this method.

1. We are taking an Example of different monthly scores of our team members, as you can see in the screenshot below. In this screenshot, we are going to swap the monthly scores of Column D to Column C and Vice-versa.

we are going to swap the monthly scores of Column D to Column C and Vice-versa.

2. Now, you have to select the column that you want to swap. In our case, we are selecting column D by clicking at the top on Column D. Look at the screenshot to understand better.

select the column that you want to swap | swap columns or rows in Excel

3. After you have selected the column you want to swap, you have to bring your mouse cursor down to the edge of the line, where you will see that the mouse cursor will turn from a white plus to a four-sided arrow cursor.

bring your mouse cursor down to the edge of the line | swap columns or rows in Excel you will see that the mouse cursor will turn from a white plus to a four-sided arrow cursor.

4. When you see a four-sided arrow cursor after placing the cursor on the edge of the column, you have to hold the shift key and left-click to drag the column to your preferred location.

5. When you drag the column to a new location, you will see an insertion line after the column where you want to move your entire column.

6. Finally, you can drag the column and release the shift key to swap the entire column. However, you may have to change the column heading manually depending upon the data you are working on. In our case, we have monthly data, so we have to change the column heading to maintain the sequence.

you can drag the column and release the shift key to swap the entire column

This was one method for swapping the columns, and similarly, you can use the same method to swap the data in the rows. This dragging method may require some practice, but this method can come in handy after you have mastered it.

Also Read: How to convert Excel (.xls) file to vCard (.vcf) file?

Method 2: Swap Columns by Copy/Pasting 

Another easy method to swap columns in Excel is the copy/pasting method, which is pretty easy to use for users. You can follow these steps for this method.

1. The first step is to select the column that you want to swap by clicking on the column header. In our case, we are swapping Column D to Column C.

select the column that you want to swap by clicking on the column header.

2. Now, cut the selected column by right-clicking on the column and choosing the cut option. However, you can also use the shortcut by pressing the ctrl + x keys together.

cut the selected column by right-clicking on the column and choosing the cut option.

3. You have to select the column before which you want to insert your cut column and then right-click on the selected column to choose the option of ‘Insert cut cells‘ from the pop-up menu. In our case, we are selecting column C.

select the column before which you want to insert your cut column and then right-click on the selected column

4. Once you click on the option of ‘Insert cut cells,’ it will swap your entire column to your preferred location. Finally, you can change the column heading manually.

Method 3: Use Column Manager to Rearrange Columns

You can use the in-built column manager to swap columns in Excel. This is a fast and efficient tool for switching columns in an Excel sheet. The column manager allows users to change the order of the columns without manually copying or pasting the data. So, before proceeding with this method, you have to install the ultimate suite extension in your Excel sheet. Now, here is how to swap columns in Excel using this method:

1. After you have successfully installed the ultimate suite add-ons on your Excel sheet, you have to go to the ‘Ablebits data’ tab and click on ‘Manage.’

go to the 'Ablebits data' tab and click on 'Manage.' | swap columns or rows in Excel

2. In the manage tab, you have to select the “Column manager.”

In the manage tab, you have to select the Column manager. | swap columns or rows in Excel

3. Now, the column manager window will pop up on the right side of your Excel sheet. In the column manager, you will see the list of all your columns.

In the column manager, you will see the list of all your columns. | swap columns or rows in Excel

4. Select the column on your Excel sheet that you want to move and use the up & down arrows in the column manager window on the left to move your selected column easily. In our case, we are selecting column D from the worksheet and using the upward arrow to move it before column C. Similarly; you can use the arrow keys for moving the column data. However, if you do not want to use the arrow tools, then you also have the option of dragging the column in the column manager window to the desired location.

Select the column on your Excel sheet that you want to move | swap columns or rows in Excel

This was another easy way with which you can swap columns in Excel. So, whatever functions you perform in the column manager window are simultaneously performed on your main Excel sheet. This way, you can have full control over all the functions of the column manager.

Recommended:

We hope this guide was helpful and you were able to understand how to swap columns or rows in Excel. The above methods are pretty easy to perform, and they can come in handy when you are in the middle of some important assignment. Moreover, if you know any other method for swapping the columns or rows, you may let us know in the comments below.

nv-author-image

Pete Mitchell

Pete is a Senior staff writer at TechCult. Pete loves all things technology and is also an avid DIYer at heart. He has a decade of experience writing how-tos, features, and technology guides on the internet.

Leave a Reply

Your email address will not be published. Required fields are marked *