In this article, you will learn how to change the positions of the two columns.
Let’s see an example. Assume you want to switch Column D (Region) and Column E (Revenue ($)). Follow the steps above, and when you release the cursor, Column E is inserted between Columns C and D, where the dark grey line is shown.
You can select and move multiple adjacent columns at once as well. The following screenshot shows a part of the process of inserting two columns (Columns D and E) between Columns B and C.
You can change the order of rows similarly to how to interchange the location of two columns.
The following picture shows what it looks like when you move two rows (Rows 4 and 5) to the space between Rows 6 and 7.
When you need to swap the contents of two rows in Google Sheets, you can use copy and paste function. Imagine you want to switch the contents of Rows 4 and 5.
The following screenshot visualizes the steps above.
Unfortunately, you can’t swap two cells in Googles Sheets. However, you can swap the contents of two cells by following the steps above (copy and paste).
Learn how to do this step-by-step in the video below 👇