TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
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
separately.
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!
Rob
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
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Develop HTML-based Help with Macromedia Dreamweaver! (STC Discount.)
**NEW DATE/LOCATION!** January 16-17, 2001, New York, NY. http://www.weisner.com/training/dreamweaver_help.htm or 800-646-9989.
Sponsored by SOLUTIONS, Conferences and Seminars for Communicators
Publications Management Clinic, TECH*COMM 2001 Conference, and more http://www.SolutionsEvents.com 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 http://www.raycomm.com/techwhirl/ for more resources and info.
