Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

2 Answers

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
add comment

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.