0

How To Swap Columns in Google Sheets

Posted by Matthew on November 7, 2017

Sheets is Google’s alternative to the MS Excel spreadsheet software. The great thing about Sheets is that it’s web-based software you can open within your browser. Thus, it’s not surprising that many prefer to set up spreadsheet tables with Google’s spreadsheet application. For starters, swapping table columns is more straightforward in Sheets.

Swap Table Columns by Dragging Them

Google Sheets users will often need to swap table columns around in their spreadsheets. That does not mean swapping the actual spreadsheet columns around, but just the table cells included within them. For example, if you had cell ranges in the A and B columns, swapping them around would move the first table column range to B and the second to A.

Swapping table columns is slightly more straightforward in Google Sheets because you can do so just by dragging one column over another. Excel users also need to press and hold the Shift key when dragging columns as mentioned in this Tech Junkie post. Dragging and dropping is probably the best way to swap table columns around in Sheets.

For an 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.

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. 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. 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

You don’t need the Ctrl + C and Ctrl + V copy and paste hotkeys to swap table columns in Google Sheets. Nevertheless, Sheets users can swap columns around by coping and pasting them despite the restrictions of the Windows clipboard. 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 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.

As such, 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.

Swap Columns With Power Tools

Google Sheets also has loads of add-ons that expands its tools. Power Tools is one of those add-ons, which you can add to Sheets from this page. That 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.

So there are a few ways you can swap columns around in Sheets. This YouTube video also shows you how to swap columns and rows around in your Google Sheets spreadsheets.

Leave a Reply

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