Swap contents of two cells in Excel

This article explains how to swap contents of two cells in MS Excel. The excel trick is shown in the image below :-

Steps

Type values in cell A1 and A2
Cut content of cell A1
Go to cell A3 and press CTRL +

About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 8 years of experience in data science. During his tenure, he has worked with global clients in various domains like Banking, Insurance, Telecom and Human Resource.

While I love having friends who agree, I only learn from those who don't
Let's Get Connected: Email | LinkedIn

Subscribe to get Email Updates!

5 Responses to "Swap contents of two cells in Excel"

Nitai Biswal18 September 2015 at 20:50
Awesome....
Anonymous28 September 2016 at 07:36
This doesn't work on Excel 2010.
Anonymous7 February 2017 at 04:21
CTRL,Shift,+ is working for Excel 2010
Anonymous9 February 2017 at 11:34
YES, Ctrl,Shift,+ is Correct - amar
bit211 June 2017 at 22:37
This is not swaping its insert cut cell. Its not switching position of content of two cells