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:BMcClain -at- centura -dot- com To:"TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com> Date:Wed, 29 Nov 2000 11:50:38 -0500
>I'd like the answer too.
>
>Last time I was faced with this challenge, I was producing a hard copy
>document and used a crude workaround to create this effect. That is,
>I printed the Word document with "blank pages" (headers and footers
>only) where the Excel spreadsheets were supposed to be. I then stuck
>the "blank pages" back in the printer and printed the spreadsheets.
>
>That approach is cumbersome--and works *only* with hard copy
documents.
>The other possible approach that's crossed my mind (though I have yet
>to try it) is to set the spreadsheet up with the text running
>vertically. (Format | Cells | select Alignment tab | set text
>orientation using the Orientation feature). In other words, set the
>spreadsheet up so a portrait orientation, when printed, will appear
>as landscape.
>
>If someone has a better approach, I am all ears.
If it's the former, use section breaks to isolate the landscape page as a
section of its own. You'll need to set margins and reformat the header and
footer so that they look OK.
If it's the latter, forget about just rotating the Excel chart in Word; that
dog ain't gonna hunt. But if image fidelity isn't crucial, consider taking
a screen shot of the ... whatever it is.... you say it's a file, but is it a
spreadsheet, a chart, or what? Anyway, get as high-quality an image as
reasonably possible, rotate it (in Paint Shop Pro, Gimp, whatever) and save
it; then paste it in.
Clear as mud, huh?
-----Original Message-----
From: Jean Cooper [mailto:Jean -dot- Cooper -at- twtelecom -dot- com]
Sent: Tuesday, November 28, 2000 6:46 PM
To: 'BMcClain -at- centura -dot- com'
Subject: RE: Rotating an inserted Excel file in Word
Thanks for your response.
I've tried creating separate sections but then I still have the problem of
having all my headers and footers being in the same place. Does that make
sense?
-----Original Message-----
From: BMcClain -at- centura -dot- com [mailto:BMcClain -at- centura -dot- com]
Sent: Tuesday, November 28, 2000 4:43 PM
To: Jean -dot- Cooper -at- twtelecom -dot- com
Subject: RE: Rotating an inserted Excel file in Word
Jean, could you try making just that page a separate section, laid out as
landscape rather than portrait? I've been where you are and it was a quick,
simple solution for me.
-----Original Message-----
From: Jean Cooper [mailto:Jean -dot- Cooper -at- twtelecom -dot- com]
Sent: Tuesday, November 28, 2000 6:37 PM
To: TECHWR-L
Subject: Rotating an inserted Excel file in Word
Before I state my question, let me just say that I know how to rotate
drawing objects and text boxes in Word. But rotating an Excel file is
proving to be much harder (for me).
Here's my situation:
I want to insert a one-page Excel file into a Word doc. The Word doc is in
portrait, the Excel file is in landscape (and needs to be -- if it were in
portrait, it wouldn't fit on the page). I'd like to insert the Excel file
into the Word doc and then rotate it 90 degrees so that it's in portrait and
can have the same headers and footers that the rest of the document has. (Or
I can rotate it before I insert it - it doesn't matter.) But when I try to
Format Object, the rotating option is always grayed out.
I've looked in Help but it keeps trying to direct me to "rotating drawing
objects." And please note that I'm not referring to rotating the text within
the cells. I'm hoping to be able to rotate the entire Excel file 90 degrees.
Any ideas???
Thank you in advance!
Jean Cooper
P.S. I know this is easy to do in FrameMaker. Sigh.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
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.
