I would like to select 2 cells in Excel and switch contents in the 2 cells without copying & pasting????

Question

I would like to switch the contents of two selected cells in the same workbook

i.e.:

NAME
-------
Brian < --- CTRL-selected
Jack
Helga < --- CTRL-selected
Marie

Then switch the contents of the 2 cells without cutting & pasting to look as follows:

NAME
-------
Helga
Jack
Brian
Marie


can this be done?

Answer 1

It is a VBA macro you need to do here

I would be happy to do this for you, once you mail me to send you the file
mail me here [e-mail]
And I will be gladd to do this for you.

After all, I am the VBAXLMan here

Answer 2

Not to my knowledge unless Excel 2007 has this feature.

All other solutions to do this require VisualBasic.

Sounds like a pretty neat idea for a new feature of Excel. Why not submit it to Microsoft.

Answer 3

use drag and drop. when move your mouse to the bordrs of the cell box u will see a plus sign, that when u click and hold to move wher u want.