» » Swap contents of two cells in Excel

Swap contents of two cells in Excel

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


Steps
  1. Type values in cell A1 and A2
  2. Cut content of cell A1
  3. Go to cell A3 and press CTRL +

Excel Tutorials : 100 Excel Tutorials

About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 7 years of experience in data science and predictive modeling. During his tenure, he has worked with global clients in various domains like banking, Telecom, HR and Health Insurance.

While I love having friends who agree, I only learn from those who don't.

Let's Get Connected: Email | LinkedIn

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*
Related Posts:
5 Responses to "Swap contents of two cells in Excel"
  1. Nitai Biswal18 September 2015 at 20:50

    Awesome....

    ReplyDelete
  2. Anonymous28 September 2016 at 07:36

    This doesn't work on Excel 2010.

    ReplyDelete
  3. Anonymous7 February 2017 at 04:21

    CTRL,Shift,+ is working for Excel 2010

    ReplyDelete
  4. Anonymous9 February 2017 at 11:34

    YES, Ctrl,Shift,+ is Correct - amar

    ReplyDelete
  5. bit211 June 2017 at 22:37

    This is not swaping its insert cut cell. Its not switching position of content of two cells

    ReplyDelete

Next → ← Prev
Subscribe to: Post Comments (Atom)