Results 1 to 7 of 7
  1. #1
    Bronze Lounger IanWilson's Avatar
    Join Date
    Dec 2000
    Location
    Bristol, United Kingdom
    Posts
    1,523
    Thanks
    0
    Thanked 1 Time in 1 Post

    Rotating a table (2003)

    I'd like to rotate a table in Word so that the rows become the columns and the columns become the rows.

    Any quick way of doing that?

    Ian

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Rotating a table (2003)

    Copy the table to the clipboard.
    Paste into an Excel worksheet.
    Copy again.
    Click elsewhere in the spreadsheet.
    Select Edit | Paste Special...
    Tick Transpose.
    Click OK.
    Copy again.
    Paste into Word.

  3. #3
    Bronze Lounger IanWilson's Avatar
    Join Date
    Dec 2000
    Location
    Bristol, United Kingdom
    Posts
    1,523
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Rotating a table (2003)

    Thanks, Hans.

    I suppose that one day Word might be able to do this without a round trip to Excel!

    Ian

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Rotating a table (2003)

    I doubt it. One could write a macro, of course; as long as the table is a straightforward grid, it wouldn't be complicated, but it could get hairy if you tried to take merged cells into account.

  5. #5
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Rotating a table (2003)

    The round trip via excel works well with merged cells, much to my surprise.

    StuartR

  6. #6
    Bronze Lounger IanWilson's Avatar
    Join Date
    Dec 2000
    Location
    Bristol, United Kingdom
    Posts
    1,523
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Rotating a table (2003)

    It certainly worked for what I needed which was a table of figures with months down the side and years across the top which I wanted to have the other way round.

    Ian

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Rotating a table (2003)

    Yes, it works without a hitch. Microsoft does some things right!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •