How to Switch Cells in Excel

Last Updated: September 23, 2019

This wikiHow will swap the value of an Excel cell with another cell's value. You can swap the data between adjoining cells or transpose the data in a row to a column using built-in Excel features. If you want to swap cell data between two separate range, you'll need a third-party tool like Kutools.

Method 1

Method 1 of 3:

Swapping Values of Adjoining Cells

Download Article

1
Open your document in Excel. You can find this program in your Start menu or Applications folder.
- You can either open your document from Excel by clicking Open from the File tab, or you can right-click the file in your file browser and click Open With .
- The cells have to be touching for this to work; for example, you can switch the info in cells A4 and B4. You can not, however, switch the information in A1 and G150.
The cell will highlight to show it has been selected.

Advertisement
The cursor will change to a 工 to indicate it will swap information.
The information in the cells will switch. ^{[1]
X
Research source}

Method 2

Method 2 of 3:

Swapping Rows for Columns

Download Article

1
Open your document in Excel. You can find this program in your Start menu or Applications folder.
- You can either open your document from Excel by clicking Open from the File tab, or you can right-click the file in your file browser and click Open With .
- In this method, you will switch your rows with your columns.
You can click and hold down the mouse button and drag over the cells to select the entire range.
The selection will be outlined with a broken line to indicate it has been copied.
When you paste your cells, you don't want to paste over any data you might need.
You'll find this in the "Home" tab of the editing ribbon above your document.
This is at the bottom of the drop-down menu.
The box will fill with a checkmark to indicate it has been selected.
The information you copied in the previous step will paste with the information transposed. ^{[2]
X
Research source}

Method 3

Method 3 of 3:

Swapping Ranges using Kutools

Download Article

Download and install Kutools from https://www.extendoffice.com/download/kutools-for-excel.html . You can try Kutools for 60 days before purchasing the license for $39.00. The program does not work with Macs.
2
Open your document in Excel. You can find this program in your Start menu or Applications folder.
- You can either open your document from Excel by clicking Open from the File tab, or you can right-click the file in your file browser and click Open With .
You'll find this in the ribbon above your document.
You'll find this button on the left of the Kutools menu.
You'll find this under the header "Swap Range 1".
The cells on your document will be highlighted to indicate they are selected.
You'll find this under the header "Swap Range 2".
The cells on your document will be highlighted to indicate they are selected. The cells or cell ranges you have selected will switch information.
The information in the selected cells will switch. ^{[3]
X
Research source}