Rotate Excel Table in Word document
David Bauguess
cells (no formulas). I want to put it in a Word document as a table. I want
to rotate/orient the entire table (with column & row sizes unchanged) 90
degrees to the left, so cell 1A is at the bottom left corner of the left
facing page and the columns extend from the left page across to the right
facing page.
I can copy and paste it, but I can't figure out how to rotate the entire
table. I will be grateful for any guidance. Thanks!
Jim Gordon
There may be a better way - probably just taking a screen shot and rotate
would be best.
But if you want to fiddle...
In Excel drag the camera command to a toolbar. Then select the range of
cells you want. Format the cells and adjust the alignment 90 degrees.
Then select the range of cells and click the camera command. Then click on
the worksheet to create a camera object.
Copy the camera object and then paste the result into a Word document.
Personally, I'd rotate the text in Excel and then do a screen shot.
-Jim Gordon
Mac MVP
All responses should be made to this newsgroup within the same thread.
Thanks.
Find Macintosh experts in your hometown. Join a user group:
http://www.microsoft.com/mindshare/default.asp
http://www.apple.com/usergroups/
----------
In article <BAA329AD.486E%dbau...@daeo.net>, David Bauguess
David Bauguess
implement them, but without success. Here are the problems I've encountered:
1. When I used the camera to make an object, the rotate command was not
available.
2. I was able to rotate a screenshot in Appleworks and get it into Word, but
the text was pixilated when I printed.
3. When I rotate the text, the formatting is wrecked. What I want to do is
rotate the entire spreadsheet, not just the text.
In summary: is there a way to rotate the entire spreadsheet (90 degrees to
the left) without degrading the print quality of the text
Thanks.
David B.
?
in article eVKltyW8...@TK2MSFTNGP12.phx.gbl, Jim Gordon at
gold...@hotmail.com wrote on 3/23/03 6:47 PM:
Elliott Roper
I think you are using the wrong program. Word is hopeless at spreads.
I have been playing with Adobe InDesign2 over the weekend. I'll never
use Word for a manual again. In fact, if I could find a way of doing
mail merge in InDesign, and spread the gospel to my collaborators, I'd
hang up my Word gloves forever.
I think your only recourse is to do it in Excel. Look up 'transpose' in
Excel's help. Split your sheet into two for eventual facing pages, left
and right, then transpose each of them
Elliott Roper
<ell...@yrl.co.uk> wrote:
> In article <BAA329AD.486E%dbau...@daeo.net>, David Bauguess
> <dbau...@daeo.net> wrote:
>
> > I am writing a manual. I have an Excel spreadsheet with only text in the
> > cells (no formulas). I want to put it in a Word document as a table. I want
> > to rotate/orient the entire table (with column & row sizes unchanged) 90
> > degrees to the left, so cell 1A is at the bottom left corner of the left
> > facing page and the columns extend from the left page across to the right
> > facing page.
> I think your only recourse is to do it in Excel. Look up 'transpose' in
> Excel's help. Split your sheet into two for eventual facing pages, left
> and right, then transpose each of them
Sorry to reply to my own post, but that advice I gave was rubbish.
Transpose does not put the cells in the right places.
I tested it after posting, not before. You *could* make extra
worksheets with the cells there pointing back to the orginal sheet's
cells, but with the cells positions all rotated how you want. (either
tiresomely by hand, or with a clever formula). You would also need to
rotate the text in the cells. I tested that sort-of, and it works all
the way back to Word.
Another way would be to create a new section with landscape orientation
in Word for the two table pages, but that would screw up your running
heads etc. in the manual, as well as destroying any chance of creating
the manual as a PDF thanks to Word's misdesigned Section object.
Beth Rosengard
I've had similar problems when importing clip art into Word (I'm in 2001, by
the way; you didn't state your version number!). It looks fine on screen
but prints pixilated.
I stumbled across a solution, though I have no idea why it works. I open
the graphic in GraphicConverter, then copy and paste it into Word where it
will now print just fine. Same result with pixilated objects after rotating
them. I do not convert it in any way; just open, copy and paste or open,
rotate, copy and paste.
If you have GraphicConverter or can download a trial version (I don't know
if one is available, but you could check at www.lemkesoft.com), then open
the camera object (try it with both AppleWorks and Word) in GC, rotate it
and copy/paste into Word.
Hope this helps.
--
Beth Rosengard
Mac MVP
Mac Word FAQ: <http://www.mvps.org/word/FAQs/WordMac/index.html>
Entourage Help Page: <http://www.entourage.mvps.org/toc.html>
On 3/23/03 3:23 PM, in article BAA3F26F.48DD%dbau...@daeo.net, "David
Jim Gordon
Here are the steps that I had in mind when I wrote my reply:
Display the worksheet in Excel.
Use either Shift+Apple+3 (entire screen) or
Shift+Apple+4+Drag to select a screen area.
Either way you get a picture file on your startup drive (OS 8&9) or
desktop (OSX)
In Word, choose Insert>Picture>From File
When the picture is in Word, control-click the picture and choose Edit
Picture
When the picture editor opens click the picture to select it, then on the
Drawing toolbar click the Rotate button. The corners should become green
dots.
Drag a dot to rotate the picture.
Click the Reset Picture Boundary button
Click the Close button to return to the document
-Jim Gordon
Mac MVP
All responses should be made to this newsgroup within the same thread.
Thanks.
Find Macintosh experts in your hometown. Join a user group:
http://www.microsoft.com/mindshare/default.asp
http://www.apple.com/usergroups/
----------
In article <BAA3F26F.48DD%dbau...@daeo.net>, David Bauguess