Allow Excel to orient/align text 180 degrees

  • Thread starter Thread starter Guest
  • Start date Start date
Are you sure you mean 180 degrees?

This would leave the text upsidedown and backwards which cannot be done unless
you take a picture of the tert and rotate it.

Do you perhaps mean "reverse the order of the text from front to back" which
would leave it rightside up with letters reversed?

That can be done with a User Defined Function.

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


Gord Dibben Excel MVP
 
I remember somebody suggesting that you "think sideways." That is, orient
the main text at 90 degrees and the upside-down text at minus 90 degrees,
using:
Format >> Cells >> Alignment >> Orientation


(This might not meet your needs if you use Excel headers, but it's one
way.)
 
You must log in or register to reply here.

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

why we can not get 180 degree in alignment in orientation? 4
Formatting alignment - can I show text upside down? 5
Rotating Text 180 6
flip text 180 Degrees 9
How to rotate text in textbox 180 degrees? 4
How can I rotate an XL worksheet 180 degrees 1
Orientation of text in an autoshape 2
FORMAT CELLS ALIGNMENT 2

Back
Top