2 Ways to Move or Swap Columns or Rows in Excel

In an Excel file, sometimes you may input some information to the wrong cells. Hence you should change the position. Therefore, today we have the Excel tips of moving or swapping columns or rows in a worksheet.

Sometimes in an Excel file, you need to input a lot of information into it. But things are not always perfect, and Excel files are no exception. There is a possibility that you need to switch information of different columns or rows. And for instance, here you can see a worksheet of several employees.Sales Volume for Swapping 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. Thus, now you need to swap the two columns. And in the following context, we will introduce two ways to solve this problem.

Copy and Paste

This is a very common method for many operations in Excel. And in this condition, you can also use this method. And the following are the steps.

  1. Create a new column between the column C and column D.Create a New Column
  2. And then select the data in column C.
  3. Press the keys “Ctrl + X”.
  4. Click the cell D1.
  5. And then press the key “Ctrl + V”.Copy Column
  6. And now select the data in column E.
  7. Press the keys “Ctrl + X”.
  8. Click the cell C1.
  9. And then press the key “Ctrl + V”.Copy Column to column C
  10. Input the header “season 2” into the cell D1.
  11. And then delete the column E in the worksheet.The Changed Columns

After all the above steps, now you have corrected the data and get a new worksheet. And this method is also suitable for swapping rows.

A Better Way to Swap Adjacent Columns

  1. Select the data in Column C.
  2. Press the key “Shift” on the keyboard and hold it.
  3. Move your mouse to the right border. Then you see the shape like the image shows, click your mouse.The Shape of Mouse
  4. Drag it to the right border of column D. and you will see this shape.The New Shape

And now you can release the button and the mouse. Then you will find that the numbers change. And you can also move columns to other places that you need. In addition, the method is also suitable for swap rows.

Excel can also Cause Shock to You

While Excel is very powerful, it can sometimes cause distress to you. For example, you can’t open your Excel file. Thus, you may consider that you meet with Excel corruption. We recommend that you can use the third party tool to fix Excel file. After all, using a powerful tool is better than losing all your information.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com

Comments are closed.