This article explains how to swap contents of cells in MS Excel. The excel trick is shown in the image below :-
To swap the cells in the same column in Excel, you can follow these steps:
- Type values in cell A1 and A2
- Cut the content of cell A1 by pressing the keyboard shortcut: Ctrl + X
- Go to cell A3 and press CTRL SHIFT + (plus key on the numpad)
By following these steps, the content of cell A1 will be moved to cell A2, and cell A2 will be moved to cell A1. This effectively swaps the contents of cell A1 and A2.
Similarly, if you have data in the same row, for example, cell A1 and cell B1, you should proceed by cutting the content of cell A1 and then go to cell C1. Please refer to the steps below to swap the cells in the same row.
- Type values in cell A1 and B1
- Cut the content of cell A1 by pressing the keyboard shortcut: Ctrl + X
- Go to cell C1 and press CTRL SHIFT + (plus key on the numpad)
Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 10 years of experience in data science. During his tenure, he worked with global clients in various domains like Banking, Insurance, Private Equity, Telecom and HR.
Awesome....
ReplyDeleteCTRL,Shift,+ is working for Excel 2010
ReplyDeleteYES, Ctrl,Shift,+ is Correct - amar
ReplyDeleteThis is not swaping its insert cut cell. Its not switching position of content of two cells
ReplyDeleteNice post, keep sharing
ReplyDeleteReally nice information , i love your content
ReplyDeletegreat work , it is very informative
ReplyDeleteThank you and for the latest versions it is Ctrl, Shift, +
ReplyDeleteThe article has been updated for the latest versions of Excel. Thanks!
Delete