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.