Exchange Columns

[Treeskier]

Probably a simple question? I want to switch rows D with H and vica-versa
without corrupting or changing anything...is there a simple way to do this?
No problem?
Thanks for help

 

[Anders Silven]

Treeskier,

To shift a *column*,

- select the column
- position the cursor anywhere on the left border of the column so the cursor
turns into a arrow cross
- SHIFT-drag the column left or right wherever you want it

Works with rows up and down as well.

HTH
Anders Silven

 

[Peo Sjoblom]

Select column H, de edit>cut, select column D and do edit>insert cut cells,
repeat for previous column D now in column E but select column I and insert
the cells

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Gord Dibben]

Tree

Highlight Column D.

Move mouse pointer down to edge of cell D1 to get a cross. Hold SHIFT key and
Click and drag Column D to right of Column G. Column D will will be inserted
here.

Do same for Column H and drag to where you want it.

Gord Dibben Excel MVP

 

[Treeskier]

Thank You everyone!!!!

Tree

Highlight Column D.

Move mouse pointer down to edge of cell D1 to get a cross. Hold SHIFT key and
Click and drag Column D to right of Column G. Column D will will be inserted
here.

Do same for Column H and drag to where you want it.

Gord Dibben Excel MVP

 

[David McRitchie]

For what it's worth there are other interesting mouse features that
are very hard to find in help, and don't get as much attention as shortcuts.

Use of Mouse and keys to move, and insert rows or columns (#mouse)
Fill-Handle, Replication and use of the Mouse
http://www.mvps.org/dmcritchie/excel/fillhand.htm