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.Ĥ. Look at the screenshot to understand better.ģ. In our case, we are selecting column D by clicking at the top on Column D. Now, you have to select the column cells that you want to swap. In this screenshot, we are going to swap the monthly scores of Column D to Column C and Vice-versa.Ģ. We are taking an Example of different monthly scores of our team members, as you can see in the screenshot below. 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.ġ. The dragging method requires some practice as it could be more complex than it sounds. You can easily try any of the following methods for swapping the columns or rows in an Excel worksheet. With the swap function, you can easily swap any rows or columns without having to do it manually. This is where the swap function of Microsoft excel comes in handy. So, how do you fix this error? Doing it manually is going to take you a lot of time. 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. How to Swap Columns or Rows or Cells in Microsoft Excel Method 2: Swap Column/Row/Cells by Copy/Pasting.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |