General Question

JonnyCeltics's avatar

How do I insert an excel sheet into a word document VERTICALLY?

Asked by JonnyCeltics (2721points) December 28th, 2009

I have a excel sheet that I would like to paste onto a word doc. As an excel document, it print horizontally. This is going to be printed out, so it doesn’t matter if it reads vertically. I can paste as special, but it appears horizontally and half of the document in missing!

Help! :)

Observing members: 0 Composing members: 0

6 Answers

CyanoticWasp's avatar

Does the spreadsheet have to be “a spreadsheet” when you paste it? That is, does it need to retain its usability “as a spreadsheet”? Because if it doesn’t, I’d suggest just pasting screenshots of it, which you can rotate as you would any other graphic. (There’d probably be less storage overhead that way, too, since you wouldn’t be copying the source file, but just .JPG views of it.

JonnyCeltics's avatar

No, it does have to be a spreadsheet – I just want it to appear as one. A screenshot would do also….

jaytkay's avatar

In Excel, you can turn the spreadsheet, making columns into rows and vice versa.

1) Copy an area.
2) Right-click (Windows) or control-click (Mac) on another area and choose ‘Paste Special’
3) Check the box for ‘Transpose’
4) Click ‘OK’

Does that do what you want?

JonnyCeltics's avatar

It bring up an error message…. :/

JonnyCeltics's avatar

It’s OK, though – I have found a way around it. Thanks for your efforts!

se_ven's avatar

Can you just change the Word page layout to Landscape?

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther