Cloud Training (Online)




How to swap the cell contents quickly in Microsoft Excel ?

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.

14C67A14-5F0B-4768-80CA-1D624DEEBCDF

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.