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

M

MickG

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
 
B

Ben McBen

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
 
J

JE McGimpsey

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

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rotating Text box in Excel 2003 1
How do I rotate an inserted picture in a word doc 1
My drawing rotate/flip tool not accessible in Excel 2
How to make the text display vertically? 1
How do you rotate an equation object? 2
Why are flip or rotate options greyed out? 1
insert text within shape and rotate? 3
Free rotate option is greyed out in my Draw menu 2

Top