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:"John Fleming" <johnf -at- ecn -dot- ab -dot- ca> To:"TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com> Date:Wed, 29 Nov 2000 09:36:03 -0700
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.
> Subject: Rotating an inserted Excel file in Word
> From: Jean Cooper <Jean -dot- Cooper -at- twtelecom -dot- com>
> Date: Tue, 28 Nov 2000 16:36:56 -0700
> X-Message-Number: 90
> 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.
--
John Fleming
Edmonton, Alberta
email: johnf -at- ecn -dot- ab -dot- ca
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
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.
