Pasting tables from Excel to word and turning them

[TUS 373]

Just a quicky from a Word/Excel intermediate here....

I want to take a spreadsheet from Excel and drop it into a Word report. However, the size of the table means that it will need to go onto that page in landscape format.

How can I drop that table in 90 degrees around - WITHOUT affecting the portrait layout of the page in terms of titles, page number etc. The only thing I can do is drop it on, then set the page (and the whole bloody document! into landscape). I KNOW there must be away, its just finding how to do it......

Over to you guys, any helpers out there? TIA, Bryan

[victormeldrew]

I think you can paste special and paste as a picture, then rotate the picture.

[.Markski]

You can always have just the one page in landscape even if it's in the middle of a document.

[victormeldrew]

Incidentally you can make that one page in the word document landscape while the rest is portrait, but I know thats not want you want! You would select "This page forward" in "applies to" box on "page setup". And then repeat on the next page to put it back.

[victormeldrew]

Must type faster!

[pdV6]

.Markski said:

You can always have just the one page in landscape even if it's in the middle of a document.

But as TUS 373 points out, everything gets switched to landscape, including headers & footers.
Some folk like this look, and it makes sense when you turn the paper document through 90 degrees to read the page, but I think it spoils the overall look.

If you're not hot-linking to the spreadsheet, I'd be tempted to paste an already turned image of the sheet.

[TUS 373]

Thanks guys, you are stars! Forgot all about the paste special command - its done the trick. Also good to be reminded about how to turn a single page around!!

Thanks again - appreciated