Swop rows for columns Excel or Word
 

How do I swop rows for columns in an Excel or Word table?

Swop rows for columns Excel or Word
 

Select the range (rows or columns),
Right click in the selection and choose "Copy",
Right click in the first cell of the new location and choose "PasteSpecial",
Click on "Transpose", then <OK.

Make sure there's *no* overlap of old and new ranges.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Click" wrote in message
...
How do I swop rows for columns in an Excel or Word table?

Swop rows for columns Excel or Word
 

To swap col B and C:

Columns("B:B").Cut
Columns("D:D").Insert Shift:=xlToRight

HTH
--
AP

"Click" a écrit dans le message de news:
...
How do I swop rows for columns in an Excel or Word table?