Swap contents of two cells in Excel


Excel Course : The Ultimate Excel Programmer Course

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 +
Coursera Data Science

Excel Tutorials : 100 Excel Tutorials

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*

Related Posts:

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

  1. This doesn't work on Excel 2010.

    ReplyDelete
  2. CTRL,Shift,+ is working for Excel 2010

    ReplyDelete
  3. YES, Ctrl,Shift,+ is Correct - amar

    ReplyDelete

Next → ← Prev