Here’s a simple trick that lets you to swap the contents of the cell quickly in Microsoft Excel 2016.
How to swap the cell contents quickly in Microsoft Excel ?
1. Enter the value 11 in cell B14 and the value 78 in C14.
2. Select the cell B14 and with the shift key pressed , place the cursor in the right corner of the cell B14 and drag the cursor to the right border of C14.
3. Release the cursor as soon as you see I when dragging to the right of C14.
4. You should immediately see that the cells would be swapped.