How to Swap Cells in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on December 7, 2022

This tutorial demonstrates how to swap cells in Excel and Google Sheets.


swap cells final data


Swap Cells

Say you have values in cells A1 and B1 and want to swap them.


swap cells final data 1


Press and hold SHIFT on the keyboard, move cell A1 to the right border of cell B1, and when the cursor turns into 工, release the mouse.


swap cells 1

swap cells 2


Cells A1 and B1 are now swapped.


swap cells initial data


Note: You can also use a helper cell, where you can copy the value of cell A1, then copy the value of B1 to A1, and then copy the original value from the helper cell to B1. However, this method is much slower.

Swap Cells in Google Sheets

In Google Sheets, you can use a helper cell to swap values. You can’t swap two cells with the mouse, but if you want to swap whole columns, you can select the first column, and drag it after the second column.


google sheets swap cells 1


This swaps Column A and Column B.


google sheets swap cells 2

AI Formula Generator

Try for Free

See all How-To Articles