Download Article
Download Article
This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. Darlene has been writing and editing tech content at wikiHow since 2019. She previously worked for AppleCare, served as a writing tutor, volunteered in IT at an animal rescue, and taught as an adjunct professor for EN101 and EN102. Darlene has completed Coursera courses on technology, writing, and language. She holds both a BA (2011) and an MA (2012) from Rowan University in Writing, with a focus on workplace communication. With her extensive experience, academic background, and ongoing learning, Darlene has become the go-to grammar expert for her friends and family, as well as a skilled wordsmith for anyone in need.
This article has been viewed 58,210 times.
Learn more...
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.
Steps
-
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.
-
Click the cell you want to switch. The cell will highlight to show it has been selected.Advertisement -
Press and hold ⇧ Shift and click the cell you want to switch with. The cursor will change to a 工 to indicate it will swap information. -
Release ⇧ Shift. The information in the cells will switch.[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.
-
Select the entire data range you want to rotate. You can click and hold down the mouse button and drag over the cells to select the entire range. -
Press Ctrl+C (Windows) or ⌘ Cmd+C (Mac). The selection will be outlined with a broken line to indicate it has been copied. -
Select a cell in a blank area. When you paste your cells, you don't want to paste over any data you might need. -
Click the arrow under Paste. You'll find this in the "Home" tab of the editing ribbon above your document. -
Click Paste Special…. This is at the bottom of the drop-down menu. -
Click the box to select it next to Transpose. The box will fill with a checkmark to indicate it has been selected. -
Click OK. The information you copied in the previous step will paste with the information transposed.[2]
-
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. -
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.
-
Click the Kutools tab. You'll find this in the ribbon above your document. -
Click Range and click Swap Ranges. You'll find this button on the left of the Kutools menu. -
Click the first cell-range icon that looks like a red arrow pointing to a blue cell. You'll find this under the header "Swap Range 1". -
Click to select your first cell or cell range. The cells on your document will be highlighted to indicate they are selected. -
Click the second cell-range icon that looks like a red arrow pointing to a blue cell. You'll find this under the header "Swap Range 2". -
Click to select your second cell or cell range. The cells on your document will be highlighted to indicate they are selected. The cells or cell ranges you have selected will switch information. -
Click Ok. The information in the selected cells will switch.[3]
Expert Q&A
Tips
You Might Also Like
References
About This Article
1. Open your document in Excel.
2. Click the cell you want to switch.
3. Press and hold the Shift key while you click the other cell.
4. Release the Shift key.
