RE: Rotating an inserted Excel file in Word

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.



-----------------------------------------------------------------------


Well, if you want it, others might to, so here it comes, on-list.



Bill McClain
"Caution: Cape does not enable user to fly."
-Warning label on my son's Batman costume



-----------------------------------------------------------------------


Jean, I'm not sure I follow you, so it's time to draw pictures.


Did you want this:


+---------------------------------------------------------------------------
+
| header header header header header header header header header header
|
|
|
|
|
| +--------------------------------------------------------------+
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| | E x c e l c o n t e n t |
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| +--------------------------------------------------------------+
|
|
|
|
|
| footer footer footer footer footer footer footer footer footer footer
|

+---------------------------------------------------------------------------
+


Or this:


+---------------------------------------------------+
| header header header header header header header |
| |
| |
| |
| +-----------------------------------------+ |
| | | |
| | | |
| | E | |
| | | |
| | x | |
| | | |
| | c | |
| | | |
| | e | |
| | | |
| | l | |
| | | |
| | | |
| | s | |
| | | |
| | t | |
| | | |
| | u | |
| | | |
| | f | |
| | | |
| | f | |
| | | |
| | (rotated, of course) | |
| +-----------------------------------------+ |
| |
| |
| |
| footer footer footer footer footer footer footer |
+---------------------------------------------------+


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.


Previous by Author: RE: How can I use MS sans serif in Word?
Next by Author: RE: Formatting, proficiency (Word)
Previous by Thread: RE: Rotating an inserted Excel file in Word
Next by Thread: Source File Directories? Print Vendors?


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

Sponsored Ads


Sponsored Ads