ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Allow Excel to orient/align text 180 degrees (https://www.excelbanter.com/excel-discussion-misc-queries/3231-allow-excel-orient-align-text-180-degrees.html)

QuadJoe4x4

Allow Excel to orient/align text 180 degrees
 
Is this possible?

Gord Dibben

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

On Thu, 6 Jan 2005 13:11:06 -0800, "QuadJoe4x4"
wrote:

Is this possible?



Jay

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.)


All times are GMT +1. The time now is 02:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com