Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What would be the easiest way of copying and rotating a table made in Excel, to Word without turning it into a picture/enhanced metafile/or something alike.

I know I can use the Section Break routine, but the problem is the table needs to go into a company frame (which I cannot turn onto a landscape), so I literally need to turn the table by 90 degrees.

Any way of doing something like that ?

share|improve this question

The best I can come up with is to do the rotation in Excel - rotate the text 90 degrees in the cells (Format Cells|Alignment|Orientiation) and then reformat- and paste from there. I don't think you can rotate such objects within Word itself - or at least I can't come up with a combination of text anchors and wrapping settings that allows this.

Or there might be come VBA that could help you?

share|improve this answer
    
YUCK! But +1 because it would probably work (hope ldigas has a rotate-to-portrait monitor to work on that spreadsheet...) – AdamV Mar 25 '10 at 23:40
    
Hey, you didn't ask for an elegant solution ;-) – Rhys Gibson Mar 26 '10 at 3:44

Rather than pasting a table directly into word, paste it into a MS word text box then you can rotate it how you like.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .