Rotating Text?

[kisenhour]

Can text be rotated to a 90 degree angle (or turned sideways)within a text cell? Please advise. Thanks!!

 

[Zack Barresse]

Hi there, welcome to the board!!

Select the cell(s) in question, go to Format | Cells.. | Alignment {tab}, set the rotation desired.

HTH

 

[exceltips]

This option is very limited. Does anyone know how to flip the text upside down.

 

[pgc01]

Hi exceltips

I may be wrong but I think that text inside a cell can only be rotated from -90 to 90 degrees.

If you really need to have text upside down in some cells consider using upside down fonts. I just googled it and found some commercially available. Since I didn't spend any time searching maybe there are also free downlodable ones.

Hope this helps.
PGC

 

[fairwinds]

Hi,

You can always use WordArt and paste it in Excel.

 

[PaddyD]

or, stick the text in a cell, use the camera tool to take a picture of the cell, rotate the result & place it over the cell / wherever.

camera tool can be found here: tools | customize | commands | tools category.

 

[pgc01]

Hi Paddy

Your solution would be the ideal since the value in the picture is linked to the value in the cell (I believe it's equivalent to Paste Picture Link).

However I had already tried it and it didn't work. The picture created with the camera allows lots of things like resizing and change colour, but not rotation. Of course it may be because I have excel 2000 or because I'm doing something wrong. Could you please tell me what is your excel version?

Thanks
PGC

 

[PaddyD]

seems to work for me on 2003...

 

[pgc01]

Thank you for your answer. I've tracked down the problem at Microsoft Knowledge base. It's an excel2000 problem.

http://support.microsoft.com/kb/212240/EN-US/

Thanks again
PGC