Swapping contents of cells in Excel?

Question

Hi

I am trying to move contents of cells in excel around without using cutting / pasting. In other words, the content of A1 cell needs moved to cell B1, and B1 to A1. Is there an way to do this?

Any help much appreciated
MGB

Answer 1

Since you want to essentially swap A1 and B1 you have to do it in 3 steps. First put the mouse cursor over the edge of cell A1 until you see the white arrow instead of the plus sign. Now click and hold while you drag this cel to an unused cell in the area. Second, do the same thing to cell B1 and drag it to A1. Third, goto the cell where you moved the original A1 and drag it to B1.

This method also works with larger groups of cells if you highlite them.

Moving cells this way does not change formulas in any way.

Answer 2

If you click the cell/s you want then move the cursor over the edge it will produce four arrows in shape of a plus(+) click and drag to new position, to copy press Ctrl at new location. Obviously if you want the information in the cell you are moving too the move that info to a new cell temporary till other info moved

Answer 3

choose the cellular to the fabulous or the down cellular Edit > minimize choose the cellular to the left or the up Insert > minimize Cells minimize Cells is the comparable command that's Insert > Cells... in spite of the undeniable fact that that's shown in user-friendly terms once you have a copied or minimize cells interior the clipboard you're able to try this to each and every and each cells, columns and rows appreciate my profile, i'm the VBAXLMan