How To Swap Columns in Google Sheets
In much the same way Docs is Google’s answer to Microsoft Word, Sheets is Google’s alternative to the Microsoft Excel spreadsheet software.
The great thing about Sheets is that it is web-based software that you can open in your browser and share with multiple people. Thus, it’s not surprising that many prefer to set up spreadsheet tables with Google’s spreadsheet application. When it comes to sheer convenience, Sheets has a lot going for it. For starters, swapping table columns is more straightforward in Sheets.
Let’s take a look at three different ways you can quickly and easily swap columns in Google Sheets.
How to Swap Columns in Google Sheets
As mentioned there are three methods you can use to accomplish this: by dragging columns, by swapping column,s or by using the Power Tools add-on.
Each of these solutions will get the job done, so choose the one that you find most convenient.
Swap Table Columns by Dragging Them
The first method is to simply drag one column over another. Dragging and dropping is probably the best way to swap table columns around in Sheets.
For example, open a blank spreadsheet in Google Sheets, then input ‘Column 1’ and ‘Column 2’ in the A and B columns.
Enter ‘Jan’ in A2, ‘Feb’ in A3, ‘March’ in A4, and ‘April’ in A5. Enter some random numbers in the cells B2 to B5. It doesn’t matter what you include in that column just so long as your table is pretty much the same as the one shown in the snapshot below. It just needs to be enough to give you an idea of what you’re doing.
Click the column header A to select it. The cursor should become a hand. Then click the A column header again, and hold the left mouse button. Drag the first table column over column B. That will swap the table columns around as in the snapshot directly below.
Now Column 1 is in B and 2 is in A. Furthermore, you can also swap multiple table columns around at the same time. As an example, enter ‘Column 3’ in C and ‘Column 4’ in D. Your spreadsheet should then be something like the one below.
First, click the A column’s header to select it. Next, press and hold the Shift key and select column B, which lets you select multiple columns without de-selecting the first one. The two columns should be selected as shown directly below.
Now click the column A header and hold the left mouse button. Drag Column 2 and 1 over the C and D columns, and let go of the left mouse button. That will swap Column 2 and 1 with Columns 3 and 4, as shown below.
Swap Table Columns by Copying and Pasting
Next, Sheets users can swap columns around by copying and pasting them. You can only copy one cell range at a time to the clipboard, but can still swap table columns by pasting a second copy of the table to a blank area of the spreadsheet.
You can try this in your Google Sheets spreadsheet by selecting the cell range A1:D5. Press the Ctrl + C hotkey to copy the table. Select the cell range F1:I5, which includes exactly the same number of rows and columns as the copied table, and press Ctrl + V. That pastes a second table into the spreadsheet, as shown below.
Now you can copy and paste the table columns from cell range F1:I5 over the first table. For example, select column H and press the Ctrl + C hotkey. Then select column B and press Ctrl + V to paste Column 3 into B as below.
Column 3 is now in both the B and C columns of the first table. You can restore Column 1 in the first table by selecting the G column and pressing Ctrl + C. Click the C column header and press the Ctrl + V hotkey. Column 1 will then be in the C column of the first table.
Now, you have swapped Column 1 and Column 3 around in the first table by copying and pasting them. There’s still a second table on the spreadsheet to delete. Select the cell range F1:I5, and press the Del key to erase the duplicate table.
This method is a little more circular than just dragging the columns where you need them to be, but it’s still perfectly functional.
Swap Columns With Power Tools
Google Sheets also has loads of add-ons that expand its capabilities. Power Tools is one of those add-ons, which you can find by following this link. Among its various features, it also includes a handy Shuffle tool.
When you’ve added Power Tools to Sheets, click Add-ons > Power Tools > Start to open the sidebar shown in the snapshot directly below. Next, click Data and Shuffle to open options that you can adjust table layouts with. That includes an Entire columns option that you can swap columns with.
First, select the Entire columns option. Then click the column A header and hold the left mouse button. Drag the cursor across to the B column header to select both columns. Press the Shuffle button to swap Column 2 and 3 around.
Google Sheets is a powerful alternative to Microsoft Excel, and if you’re interested in switching over to Sheets, you may be interested in learning how to perform some of the same tasks that you normally use in Excel.
So there are a few different ways you can swap columns around in Sheets. If you’re interested in learning more about Google Sheets, make sure to check out some of our other articles, such as How To Calculate Days Between Dates in Google Sheets and How To Highlight Duplicates in Google Sheets.