Pasting an excel worksheet into word

F

Frank Kabel

Hi
one workaround:
- copy the data in Excel
- insert the data as PICTURE within MS Word ('Edit - Paste Special')
- use the 'Draw' toolbar to rotate this picture

Note: The data is not updated within this picture if you change the
Excel file.
 
F

Frank Kabel

Hi
I just tried it (with Excel/Office 2003) and it works:
- I pasted the data as 'Picture'
- I was able to rotate in 90 degree steps (free rotation was NOT
available)

So you may check if 90 degree rotation is possible for you. Another
reason could be that this is a new feature for Office 2003 (not sure
about that)

Another option would be to use an imaging program of your choice and
rotate the graphic within this program (e.g. PaintShop or any other
similar program)


--
Regards
Frank Kabel
Frankfurt, Germany

Frank,
When I do this the rotate buttons are greyed out and I can't use
Click to expand...
them.
 
R

Rix

Thanks for your help. I'll try your other suggestions. When I tried the special paste option neither free rotation nor 90 degree rotation were available.
 
F

Frank Kabel

Hi
this option is only available in the 'Drawing' toolbar AFTER inserting
the data as picture
 
D

DDM

Rix, I'm going to hazard a guess that the reason you want to rotate the
Excel worksheet is because you're pasting more columns than will fit on a
"portrait" page. If that's the case, then rather than rotate the worksheet,
why not rotate the page?

In Word, insert a next page section break at the end of the preceeding page
(Insert > Break > Next Page), then on the new page go to page setup and
change the orientation to landscape for that section only. Then you can
paste your worksheet.

Below your worksheet, you can insert another next page section break and set
the orientation back to portrait for the rest of the document.

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com


Rix said:
How do I rotate an Excel worksheet 90 degrees when pasting it into a Word
Click to expand...
file?
 
C

CTikotin

A better way to copy from Excel into Word is as follows:

1. Select the cells to be copied.

2. *Hold down <Shift> while clicking the Edit menu.
This will give you a hidden option to Copy Picture...*
Select this and click OK.

3. Paste into Word.

4. If you need to rotate, left click the picture once to bring up th
Picture toolbar, then click the Rotate 90 degree button as needed.

The default option for Copy Picture in Excel gives you a 'Microsof
Picture' rather than a bitmap, which results in a smaller file size an
doesn't get pixelated after resizing in Word
 
Top