How I do I rotate text in an excel cell? The rotate commands is g.
 

I am trying to flip some text in an excel worksheet either as a block or opne
cell at a time. However the rotate command in the Draw toolbar is greyed out.
Anyone help?
Thanks Mick

Go to Format - Cells - then go to the allignment tab -
you will see that there is a control set in the bottom
right for doing this


tt5fn benm

If the text is in a cell, you can rotate it up to 90 degrees using
Format/Cells/Alignment...


In article ,
"MickG" wrote:

I am trying to flip some text in an excel worksheet either as a block or opne
cell at a time. However the rotate command in the Draw toolbar is greyed out.
Anyone help?
Thanks Mick

And if you mean "reverse" rather than "flip"........

Public Function RevStr(Rng As Range)
RevStr = StrReverse(Rng.text)
End Function

Usage is: RevStr(cellref)

Gord Dibben Excel MVP

On Mon, 13 Dec 2004 00:26:25 -0700, JE McGimpsey wrote:

If the text is in a cell, you can rotate it up to 90 degrees using
Format/Cells/Alignment...


In article ,
"MickG" wrote:

I am trying to flip some text in an excel worksheet either as a block or opne
cell at a time. However the rotate command in the Draw toolbar is greyed out.
Anyone help?
Thanks Mick