[mlse]

Here's a knotty problem for you!

I certainly can't figure out how to do it and I'd be grateful to anyone who can tell me how!

Basically, I have an Excell spreadsheet that will fit on one piece of A4 paper with landscape orientation.

I have a Word document which is in Portrait orientation.

What I want to do is rotate the spreadsheet through 90 degrees and insert it into my document so that it occupies a whole page - but the word page must be portrait while the spreadsheet is landscape (i.e. tipped up on its end) in the word page ... if you see what I mean!

If that's unclear, I can try and draw a little example and attach it.

Thanks in advance,

Me.

[Jay Freedman]

You cannot do that in Word -- the page with the inserted spreadsheet
must be oriented landscape. What you can do, though, is place the
header and footer so that they *appear* in the same places as on
portrait pages. See
http://www.word.mvps.org/FAQs/Format...apeSection.htm for
details.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Sat, 1 May 2010 18:12:45 +0100, mlse
.uk wrote:


Here's a knotty problem for you!

I certainly can't figure out how to do it and I'd be grateful to anyone
who can tell me how!

Basically, I have an Excell spreadsheet that will fit on one piece of
A4 paper with landscape orientation.

I have a Word document which is in Portrait orientation.

What I want to do is rotate the spreadsheet through 90 degrees and
insert it into my document so that it occupies a whole page - but the
word page must be portrait while the spreadsheet is landscape (i.e.
tipped up on its end) in the word page ... if you see what I mean!

If that's unclear, I can try and draw a little example and attach it.

Thanks in advance,

Me.

[Jay Freedman]

You cannot do that in Word -- the page with the inserted spreadsheet
must be oriented landscape. What you can do, though, is place the
header and footer so that they *appear* in the same places as on
portrait pages. See
http://www.word.mvps.org/FAQs/Format...apeSection.htm for
details.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Sat, 1 May 2010 18:12:45 +0100, mlse
.uk wrote:


Here's a knotty problem for you!

I certainly can't figure out how to do it and I'd be grateful to anyone
who can tell me how!

Basically, I have an Excell spreadsheet that will fit on one piece of
A4 paper with landscape orientation.

I have a Word document which is in Portrait orientation.

What I want to do is rotate the spreadsheet through 90 degrees and
insert it into my document so that it occupies a whole page - but the
word page must be portrait while the spreadsheet is landscape (i.e.
tipped up on its end) in the word page ... if you see what I mean!

If that's unclear, I can try and draw a little example and attach it.

Thanks in advance,

Me.

[Paul H]

If you don't need to link the table back to the Excel file, you can paste an
image of the spreadsheet into the Word document as an enhanced metafile or
bitmap, then rotate it 90 degrees.

"mlse" wrote:


Here's a knotty problem for you!

I certainly can't figure out how to do it and I'd be grateful to anyone
who can tell me how!

Basically, I have an Excell spreadsheet that will fit on one piece of
A4 paper with landscape orientation.

I have a Word document which is in Portrait orientation.

What I want to do is rotate the spreadsheet through 90 degrees and
insert it into my document so that it occupies a whole page - but the
word page must be portrait while the spreadsheet is landscape (i.e.
tipped up on its end) in the word page ... if you see what I mean!

If that's unclear, I can try and draw a little example and attach it.

Thanks in advance,

Me.




--
mlse
.

[Paul H]

If you don't need to link the table back to the Excel file, you can paste an
image of the spreadsheet into the Word document as an enhanced metafile or
bitmap, then rotate it 90 degrees.

"mlse" wrote:


Here's a knotty problem for you!

I certainly can't figure out how to do it and I'd be grateful to anyone
who can tell me how!

Basically, I have an Excell spreadsheet that will fit on one piece of
A4 paper with landscape orientation.

I have a Word document which is in Portrait orientation.

What I want to do is rotate the spreadsheet through 90 degrees and
insert it into my document so that it occupies a whole page - but the
word page must be portrait while the spreadsheet is landscape (i.e.
tipped up on its end) in the word page ... if you see what I mean!

If that's unclear, I can try and draw a little example and attach it.

Thanks in advance,

Me.




--
mlse
.

[mlse]

Originally Posted by Jay Freedman

http://www.word.mvps.org/FAQs/Format...apeSection.htm

That's perfect! Thank you.