How to Swap Two Cells in Google Sheets

Learn to switch rows and columns with ease

3 min. read

Updated onOctober 4, 2023

updated onOctober 4, 2023

Share this article

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Key notes

Sheets is one of the foremost web apps forspreadsheetswith which users can set up data tables.

Google Sheetsusers will sometimes need to swap multiple cells in rows and columns on their tables.

For example, a Sheets user might need to swamp all the cell values within column B with the numbers in column C.

That user could fall back on copying and pasting column cell ranges with theCtrl+CandCtrl+Vhotkeys, but there are two better methods, and we will present them to you.

How do I swap cells in Google Sheets?

1. Drag and drop two columns/rows to switch them

Open the Google Sheets spreadsheet which contains the columns you want to swap in your browser. In our example, we will be using columns B and C.
Left-click the letter of column B. The cursor should turn into a hand.
Press and hold the left mouse button to drag column B over column C.

4.Then release the left mouse button. When you do that, you’ll have swamped the two columns’ cell values around as in the snapshot directly below.

You can swamp the cell contents of two adjacent rows in exactly the same way. Just double left-click a row number, hold the left mouse button, and drag it over another row to swamp it with.

You can quickly swap two cells in Google Sheets in a few clicks. All you need to do is drag and drop one column or row onto the other, and they will switch places.

2. Use Power Tools to switch two cells in Google Sheets

That’s how you can swap cells in rows and columns around in Sheets without copying and pasting. You can swap cells in columns and rows more quickly with the drag-and-drop method and Power Tools.

Write down in the comments section below any questions you have about the process of swapping two or more cells in Google Sheets.

How to Swap Two Cells in Google Sheets#

How do I swap cells in Google Sheets?#

1. Drag and drop two columns/rows to switch them#

2. Use Power Tools to switch two cells in Google Sheets#

How to Swap Two Cells in Google Sheets

How do I swap cells in Google Sheets?

1. Drag and drop two columns/rows to switch them

2. Use Power Tools to switch two cells in Google Sheets