Exchange Columns

  • Thread starter Thread starter Treeskier
  • Start date Start date
T

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
 
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
 
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
 
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
 
Thank You everyone!!!!


Gord Dibben said:
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
Click to expand...
 
Back
Top