Swap cell contents

H

H Cole

I am after the shortcut for swapping the contents of
adjacent cells or columns.
Thanks
 
D

David McRitchie

Hi H Cole......,
To move a column(s), select the column(s) then
hold the Shift key and drag the column boundary with the
mouse to where to want it between two other columns.

An important point your formulas are moved, so everything
works out well.

More mouse things similar to this:
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse
If you can't find it in help then whether it's in help or not
isn't going to do much good, but the mouse things are
poorly documented or indexed in help.
 
B

BKlugh

If you are talking about one cell for one cell, highlight the cells you wish to move, right click, click on "cut"
Highlight the cells you wish to insert the cut cells in fron of and right click, then click "paste"

----- H Cole wrote: ----

I am after the shortcut for swapping the contents of
adjacent cells or columns
Thank
 
Top