RE: Rotating an inserted Excel file in Word

Subject: RE: Rotating an inserted Excel file in Word
From: Robert -dot- Partridge -at- MONDEX -dot- com
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Wed, 29 Nov 2000 17:17:07 -0000

No simple solution for this one. Word doesn't allow you to rotate an excel
sheet. There are several ways to do this, none of which are really perfect:

1. Add your headers and footers to the excel sheet and print it out

2. Add a new section in the Word document and rotate the page. This means
that your headers and footers come out along the long edges of your page.
Not exactly what you want.

3. Copy the cells in Excel, paste into Word as a picture or EMF. You can now
rotate the spreadsheet... BUT, it doesn't rotate the text in each text box,
so you'd have to individually rotate the text in each cell. A royal pain in
the backside.

4. Copy the spreadsheet, paste into Powerpoint (or an image editing tool) as
an EMF. Double click on picture in Powerpoint to convert it to a Word Office
drawing. Select all then group the elements. Rescale and rotate the picture,
then copy the graphic from powerpoint and paste into Word as an EMF. Voila!
It is no longer an excel file, so can't be fiddled with in Word. There might
be some degradation in quality (rasterisation in fonts etc.) depending on
how you pasted it at each stage. I used EMF as both pastes, and was able to
preserve the quality. You might have to convert it to a bitmap as you paste
it to get it to work.

5. Print the sheet to PS and import as PS or PDF.

6. Print a blank page in the word doc and overprint the spreadsheet.

There may be more workarounds. Why can't the Office suite _really_ work
together as they should? I waste a lot of time fiddling around just because
all the packages similar things in totally different ways. Argh!


Robert Partridge
Technical Author

Tel: +44 (0)20 7557 5098
Fax: +44 (0)20 7557 5298
Email: robert -dot- partridge -at- mondex -dot- com


The information in this Email and any attached files are confidential,
may also be privileged, and is intended solely for the addressee.
Access, copying, dissemination, distribution or re-use of the information
in this Email and any attached files by anyone else is unauthorised.
Any views or opinions presented are solely those of the author and do not
necessarily represent those of Mondex International Limited or any of its
affiliates. If you are not the intended recipient, all copies of the Email
and associated files in your possession should be destroyed.

Mondex International Limited
47-53 Cannon Street
London EC4M 5SH
United Kingdom
Registered No: 3122085, England

Phone: +44 (0)20 7557 5000
Fax: +44 (0)20 7557 5200
Email: postmaster -at- mondex -dot- com


Develop HTML-based Help with Macromedia Dreamweaver! (STC Discount.)
**NEW DATE/LOCATION!** January 16-17, 2001, New York, NY. or 800-646-9989.

Sponsored by SOLUTIONS, Conferences and Seminars for Communicators
Publications Management Clinic, TECH*COMM 2001 Conference, and more or 800-448-4230

You are currently subscribed to techwr-l as: archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit for more resources and info.

Previous by Author: Experiences writing Z specs
Next by Author: Search engines and PDF files
Previous by Thread: RE: Rotating an inserted Excel file in Word
Next by Thread: RE: Rotating an inserted Excel file in Word

What this post helpful? Share it with friends and colleagues:

Sponsored Ads

Sponsored Ads