How to Move (Swap) Rows or Columns in Excel

Date:2021-5-17 Author:Sandra

When we find that the two columns of data in the Excel table are in the wrong position, what method should be used to swap the positions of the two columns of data?

Take the B and C columns in the following figure as examples. Before I know the method, I even cut the two columns to other positions and then copy and paste them again.

How to Move (Swap) Rows or Columns in Excel

Let’s get to a simple and fast way.

Highlight or select the B column first.

Press and hold the Shift key, then drag the B column.

Remember to put the mouse pointer to the edge of the selection until it changes from a regular cross to a 4-sided arrow cursor.

How to Move (Swap) Rows or Columns in Excel

If you want to move rows’ position, do it in this same manner.

How to Move (Swap) Rows or Columns in Excel

Ok, congratulations, you have improved your work efficiency. And there’s nothing wrong with saving yourself some time.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

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