Home Google How to Swap Values Between Cells, Rows or Columns in Google Sheets

How to Swap Values Between Cells, Rows or Columns in Google Sheets

MashTips is supported by its audience. When you purchase through links on our site, we may earn an affiliate commission at no extra cost to you.

Google Sheets is considered as an excellent alternative to Microsoft Excel for a number of reasons. First, you don’t need to pay any fee for a license, as it is completely free. Plus, you are not required to carry your computer everywhere, you can access Google Sheets from any device like a smartphone or tablet. Even if there is no internet connection, you can work with the sheets offline and sync the changes later when you are online.

In a nutshell, you can use Google Sheet for doing anything which can be done on Microsoft Excel. In this article, let’s see how to swap values between cells, rows, or columns in a Google Sheet.

How to Swap Two Rows in Google Sheets

Let’s imagine that you are preparing an expense report on the Google Sheet to submit to your company. And, you need to switch the values of two rows in your report. There are multiple ways to swap two rows in a Google Sheet as given below.

Method 1: Drag & Drop Using Mouse to Swap Two Rows

Let’s take a look at the simplest way to swap two rows in a Google Sheet with your mouse. In this example, let’s assume that you would like to swap row 20 with row 21.

Google Sheets Select Row

  1. Left-click on number titled 20 in order to select the entire row.
  2. Keep your mouse pointer on number 20, left-click and drag the entire row.
  3. (While you are moving the mouse, you will see a grey outline that covers the row, as you move)
  4. Release the left mouse button after row 21 is covered by the grey box.

Google Sheets Swap Rows

That’s it. Now, you have successfully swapped the values of two adjacent rows in Google Sheet.

Method 2: Swap Google Sheet Rows Using Power Tools Extension

Are you a tech-savvy person who loves new tools? Then, you can use the Power Tools Extension to swap two adjacent rows in a Google Sheet.

  1. First, you need to install the Power Tools Chrome Extension. Navigate to this link and click Get button.
  2. Here, you will be prompted to choose a Google account. Make sure you select the account which is used to create the Google Sheets file. Follow the on-screen instructions to complete the installation.

Now, let’s see how to swap the values of two adjacent rows using this extension.

Google Sheets Swap rows with Power tools original

  1. Launch Google Sheets and select the two rows that need to be swapped. After selecting one row, press Shift Key on your keyboard to select the adjacent row.
  2. Then, click Add-ons tab located on the top and navigate to Power Tools->Start.
  3. Here, a new rectangular window will be displayed on the right as shown below:
  4. Click the three-dot icon on the Power Tools window.
  5. Next, click the drop-down arrow and select Flip entire rows from the list of menu options.

Google Sheets Swap rows with Power tools (result)

Now, if you look at your screen, the contents of the two rows you had selected earlier should have been swapped. Do remember that this method only works for adjacent rows. If the rows are not adjacent, then you can use the Copy/Paste method described below.

Related: How to Share Specific Sheet from Google Spreadsheet

Method 3: Copy/Paste to Swap Two Rows of Google Sheet

The above two methods will work only for adjacent rows. Now, let’s imagine that you need to swap row number 19 with row 24. In that scenario, you have to follow the old school method of copy & paste as explained below.

Google Sheet Swap rows using Copy-Paste original

  1. Left-click on number titled 19 in order to select the entire row.
  2. Press CTRL and X keys on your keyboard together.
  3. Next, select a blank row outside the table, let’s say row 28 and left-click on that row.Google Sheet Copy Contents Blank row
  4. Then, press CTRL and V keys on your keyboard together.
  5. Next, select row 24 and press CTRL + X keys.
  6. Select row 19 and press CTRL + V keys to paste contents of row 24 to 19.
  7. Finally, cut row 28 (CTRL+X) and paste (CTRL+V) on row 24.

Google Sheet Swap rows copy paste result

Instead of pressing keys on your keyboard, you can also right-click the row and select Cut/Copy/Paste from the menu, based on your need.

Also read: What is Sharing Violation Error in Excel and How to Solve It

How to Swap Two Columns In Google Sheets

Unlike rows, swapping two columns is pretty much easier when compared with Microsoft Excel. First, let’s see how to swap two columns using a mouse.

Using Mouse to Swap Two Columns In Google Sheets

It is not necessary that the columns should be adjacent. You can drag any two columns in a Google Sheet by just dragging the mouse. Let’s imagine that you need to swap columns titled A and B.

Google Sheets Swap columns with drag (original)

  1. Left-click on A to select that column.
  2. Keep the mouse pointer on A and drag it to column B. (While you are moving the mouse, you will see a grey outline that covers the column, as you move)
  3. Release the left mouse button after column B is covered by the grey box.

Google Sheets Swap columns with drag (result)

That’s it. Now, you have successfully swapped the values of two adjacent columns in Google Sheet. By following the above, you can swap any two columns in Google Sheet.

Swap Two Columns In Google Sheets with Power Tools Extension

Now, let’s see how to swap two adjacent columns in Google Sheets using Power Tools extension.

Google Sheets Swap columns with power tools

  1. Launch Google Sheets and select the two columns that need to be swapped. After selecting one column, press Shift Key on your keyboard to select the adjacent column.
  2. Then, click Add-ons tab located on the top and navigate to Power Tools->Start.
  3. Here, a new rectangular window will be displayed on the right as shown below:
  4. Click the three-dot icon on the Power Tools window.
  5. Next, click the drop-down arrow and select Flip entire columns from the list of menu options.

Google Sheets Swap columns with power tools (result)

How to Swap Two Cells In Google Sheets

Do you need to swap only two cells instead of an entire row or column? The simplest method to do that is by using Power Tools extension. Let’s see how to do that.

Swap Two Cells Using Power Tools Extension

Let’s assume that you would like to swap two adjacent cells.

Google Sheets Swap cells

  1. Left-click on the first cell.
  2. Next, press Shift key on your keyboard and select the second cell.
  3. Then, click Add-ons tab located on the top and navigate to Power Tools->Start.
  4. Here, a new rectangular window will be displayed on the right as shown below:
  5. Click the three-dot icon on the Power Tools window.
  6. Next, click the drop-down arrow and select Flip cells horizontally/Flip cells vertically based on your need.

That’s it. Now you have swapped the values of two adjacent cells. This method will work only for adjacent cells. If the cells are not adjacent, then you can use the Copy/Paste method explained earlier to flip the values of two cells.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Free Newsletter

Read More...

How to Get Google Form Email with Form Content

Forms by Google (or Google Forms) is the world's leading administration tool. Not only does Google Forms allow users to create different types of...

How to Setup Dual Display in Windows 10

Windows can natively support quite a few external displays. Most of the time, it's the hardware that sets the limit. The most commonly used...

How to Hide Home Bar on Android 10

A major disadvantage of on-screen navigation buttons on Android has been the screen real estate they end up taking. The full gestural navigation on...

How to Use Shortcuts App on iPhone?

Shortcuts App is the much-awaited feature of the iOS 12. What's the significance of this app? Why there is so much hype created for...

How to Record iPhone Screen on Mac with Voice

Do you want to create a movie with all your screen activities on your iPhone? If you own an iPad or iPhone you can...

How to Remove Write Protection & Format Write Protected USB Drive

USB Drives are a widely used way to transfer data between different devices. They do tend to run into errors or problems though, although...