G
Guest
How do I rotate an Excel worksheet 90 degrees when pasting it into a Word file?
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.
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.
G
Guest
Frank
When I do this the rotate buttons are greyed out and I can't use them.
When I do this the rotate buttons are greyed out and I can't use them.
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
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
them.
G
Guest
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
this option is only available in the 'Drawing' toolbar AFTER inserting
the data as picture
J
JE McGimpsey
IIRC, free rotation from the picture toolbar is available in MacXL only.
F
Frank Kabel
Hi JE
you Mac users really do have better programs
you Mac users really do have better programs
J
JE McGimpsey
Where do you think the R&D for WinXL occurs?
F
Frank Kabel
lol
I know
I know
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
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
file?Rix said:
G
Guest
DDM
Thanks! That worked great. And it was so simple
Rix
Thanks! That worked great. And it was so simple
Rix
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
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