After all, using a powerful tool is better than losing all your information. We recommend that you can use the third party tool to fix Excel file. Thus, you may consider that you meet with Excel corruption. For example, you can’t open your Excel file. While Excel is very powerful, it can sometimes cause distress to you. In addition, the method is also suitable for swap rows. And you can also move columns to other places that you need. Then you will find that the numbers change. and you will see this shape.Īnd now you can release the button and the mouse.

Drag it to the right border of column D.

Then you see the shape like the image shows, click your mouse.

Press the key “Shift” on the keyboard and hold it.

And this method is also suitable for swapping rows.

And then delete the column E in the worksheet.Īfter all the above steps, now you have corrected the data and get a new worksheet.

Input the header “season 2” into the cell D1.

Create a new column between the column C and column D.

And in this condition, you can also use this method. This is a very common method for many operations in Excel. And in the following context, we will introduce two ways to solve this problem.

Thus, now you need to swap the two columns. When you need to check the numbers of each person and each season, you find that the data of season 1 and season 2 is in the wrong place. And for instance, here you can see a worksheet of several employees. There is a possibility that you need to switch information of different columns or rows.

But things are not always perfect, and Excel files are no exception. Sometimes in an Excel file, you need to input a lot of information into it. Therefore, today we have the Excel tips of moving or swapping columns or rows in a worksheet. In an Excel file, sometimes you may input some information to the wrong cells.

Content from tor websites magic kingdom