Swap cell contents in Excel?
Problem
Is there an easy way to swap the contents of two cells in Microsoft Excel? By easy, I mean either a keyboard shortcut or menu item, without involving copying to temporary cells or writing VBA scripts or anything like that. In other words, I'm looking for a way to just select two cells and click some menu item or press some key combination that will swap their contents. Surely, there has got to be a way to do this?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Fix for: Swap cell contents in Excel?
From: http://www.extendoffice.com/documents/excel/860-excel-swap-contents-of-two-cells.html Sometimes, there are two adjoining cells need to be swapped. We can manually do it easily. Look at the following screenshot, I want to swap cell A4 and B4, please do as follows: Select the cell you want to swap. In this example, select cell A4. Press Shift key, and put the cursor at the right border. Then drag the cursor to the right border of cell B4. When there displays “工”, release the mouse. And the …
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix