How do I swop rows for columns in an Excel or Word table?
How do I swop rows for columns in an Excel or Word table?
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" <[email protected]> wrote in message
news:[email protected]...
> How do I swop rows for columns in an Excel or Word table?
To swap col B and C:
Columns("B:B").Cut
Columns("D:D").Insert Shift:=xlToRight
HTH
--
AP
"Click" <[email protected]> a écrit dans le message de news:
[email protected]...
> How do I swop rows for columns in an Excel or Word table?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks