Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've created a text box and I want to rotate it 30 degrees.
I've right clicked and picked "Format Text Box" and selected to "Size" tab. The rotate box is shaded and I cannot change this setting. Why not? -- Garyw |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Check under the 'Alignment' tab.
HTH, Paul "Garyw" wrote in message ... I've created a text box and I want to rotate it 30 degrees. I've right clicked and picked "Format Text Box" and selected to "Size" tab. The rotate box is shaded and I cannot change this setting. Why not? -- Garyw |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The "Alignment" tab only deals with the text. The box itself doesn't rotate
with text. -- Garyw "PCLIVE" wrote: Check under the 'Alignment' tab. HTH, Paul "Garyw" wrote in message ... I've created a text box and I want to rotate it 30 degrees. I've right clicked and picked "Format Text Box" and selected to "Size" tab. The rotate box is shaded and I cannot change this setting. Why not? -- Garyw |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You cannot rotate a text box, here's a workaround from Bernard Liengme
Make a textbox with text and everything, click the textbox frame to make it active, hold down shift and do editcopy picture, paste the picture where you want it, now you can rotate it the way you rotate an autoshape by grabbing the green handle at the top -- Regards, Peo Sjoblom "Garyw" wrote in message ... The "Alignment" tab only deals with the text. The box itself doesn't rotate with text. -- Garyw "PCLIVE" wrote: Check under the 'Alignment' tab. HTH, Paul "Garyw" wrote in message ... I've created a text box and I want to rotate it 30 degrees. I've right clicked and picked "Format Text Box" and selected to "Size" tab. The rotate box is shaded and I cannot change this setting. Why not? -- Garyw |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Peo has got it. i tried it and it works. Peo - I know you can help me w/ my ?
two slots up. "Highlighting" Please see if you know the answer. "Peo Sjoblom" wrote: You cannot rotate a text box, here's a workaround from Bernard Liengme Make a textbox with text and everything, click the textbox frame to make it active, hold down shift and do editcopy picture, paste the picture where you want it, now you can rotate it the way you rotate an autoshape by grabbing the green handle at the top -- Regards, Peo Sjoblom "Garyw" wrote in message ... The "Alignment" tab only deals with the text. The box itself doesn't rotate with text. -- Garyw "PCLIVE" wrote: Check under the 'Alignment' tab. HTH, Paul "Garyw" wrote in message ... I've created a text box and I want to rotate it 30 degrees. I've right clicked and picked "Format Text Box" and selected to "Size" tab. The rotate box is shaded and I cannot change this setting. Why not? -- Garyw |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Peo,
That worked great except for one thing. The text box has a cell reference in it. Example: Worksheet!$C$27 It doesn't work after text box is pasted into worksheet. Any ideas? -- Garyw "Peo Sjoblom" wrote: You cannot rotate a text box, here's a workaround from Bernard Liengme Make a textbox with text and everything, click the textbox frame to make it active, hold down shift and do editcopy picture, paste the picture where you want it, now you can rotate it the way you rotate an autoshape by grabbing the green handle at the top -- Regards, Peo Sjoblom "Garyw" wrote in message ... The "Alignment" tab only deals with the text. The box itself doesn't rotate with text. -- Garyw "PCLIVE" wrote: Check under the 'Alignment' tab. HTH, Paul "Garyw" wrote in message ... I've created a text box and I want to rotate it 30 degrees. I've right clicked and picked "Format Text Box" and selected to "Size" tab. The rotate box is shaded and I cannot change this setting. Why not? -- Garyw |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If the textbox points at a cell, why use the text box at all?
Why not just edit|copy the picture select a new location shift-edit|paste picture link And rotate that picture. Garyw wrote: Peo, That worked great except for one thing. The text box has a cell reference in it. Example: Worksheet!$C$27 It doesn't work after text box is pasted into worksheet. Any ideas? -- Garyw "Peo Sjoblom" wrote: You cannot rotate a text box, here's a workaround from Bernard Liengme Make a textbox with text and everything, click the textbox frame to make it active, hold down shift and do editcopy picture, paste the picture where you want it, now you can rotate it the way you rotate an autoshape by grabbing the green handle at the top -- Regards, Peo Sjoblom "Garyw" wrote in message ... The "Alignment" tab only deals with the text. The box itself doesn't rotate with text. -- Garyw "PCLIVE" wrote: Check under the 'Alignment' tab. HTH, Paul "Garyw" wrote in message ... I've created a text box and I want to rotate it 30 degrees. I've right clicked and picked "Format Text Box" and selected to "Size" tab. The rotate box is shaded and I cannot change this setting. Why not? -- Garyw -- Dave Peterson |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Go to Insert-Picture-Autoshape and choose your shape. Then add text. Then
(ex. rectangle) you should have a green dot that you can click and drag to rotate the box and it's contents. You should not have to right click and format the box. You can rotate the autoshape at anytime after it is created. "Garyw" wrote: I've created a text box and I want to rotate it 30 degrees. I've right clicked and picked "Format Text Box" and selected to "Size" tab. The rotate box is shaded and I cannot change this setting. Why not? -- Garyw |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
We're almost there. The shape (rectangle) will rotate to the setting I make in
"Format Autoshape" size, rotation setting. However, the text can only be rotated to vertical or horizontal. It does not rotate with the rectangle. Where is the setting for rotating it to a say 30 degree angle? -- Garyw "Teddy-B" wrote: Go to Insert-Picture-Autoshape and choose your shape. Then add text. Then (ex. rectangle) you should have a green dot that you can click and drag to rotate the box and it's contents. You should not have to right click and format the box. You can rotate the autoshape at anytime after it is created. "Garyw" wrote: I've created a text box and I want to rotate it 30 degrees. I've right clicked and picked "Format Text Box" and selected to "Size" tab. The rotate box is shaded and I cannot change this setting. Why not? -- Garyw |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need rotation schedule with 6 tables of 6 people for all to meet o | Charts and Charting in Excel | |||
Chart Rotation | Charts and Charting in Excel | |||
Team Role Rotation (number of team members is variable) | Excel Worksheet Functions | |||
How do I set up a euchre rotation schedule | Excel Worksheet Functions | |||
Schedule Rotation Question | Excel Worksheet Functions |