Download Article
Download Article
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.
-
Advertisement
-
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] X Research source
Advertisement
-
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.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Thanks for submitting a tip for review!
References
About This Article
Article Summary
X
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.
Did this summary help you?
Thanks to all authors for creating a page that has been read 54,708 times.
Advertisement
