In this article:

How to Swap Columns in Google Sheets (Easiest Way in 2024)

May 8, 2024

How to Swap Columns in Google Sheets Easily

The easiest way to swap columns in Google Sheets is the drag-and-drop method. Here's how to do it:

Step 1: Select the Column

Click on the letter at the top of the column you wish to move. This action highlights the entire column.

how to swap columns in google sheets

Step 2: Drag the Column

Move your cursor to the edge of the highlighted column until it changes into a hand icon. Then, press and hold the left mouse button.

swap columns in google sheets

Step 3: Drop the Column

Drag the column to its new desired location. You'll see a thick vertical line indicating the new position of the column as you drag it. Release the mouse button to drop the column in its new place.

google sheets swap columns
swap columns google sheets

Important Tips

  • Moving Multiple Columns: If you want to move multiple columns, click on the first column, then hold down the Shift key on your keyboard and click on the last column you want to include. This action will select all columns in between. You can then drag and drop them as a single unit.
  • Undo: If you make a mistake, you can quickly undo the action by pressing Ctrl + Z (on Windows) or Cmd + Z (on Mac).

This drag-and-drop method is particularly useful for quickly reorganizing your data without affecting the structure of your spreadsheet. However, be cautious when moving columns that are referenced by formulas in other parts of your sheet, as this can change the results of those formulas.

We hope that this article has helped you and given you a better understanding of how to swap columns in Google Sheets easily. If you enjoyed this article, you might also like our articles on how to apply conditional formatting in Google Sheets for dates within 7 days and how to keep a running total in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->