Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
QuadJoe4x4
 
Posts: n/a
Default Allow Excel to orient/align text 180 degrees

Is this possible?
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

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?


  #3   Report Post  
Jay
 
Posts: n/a
Default

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.)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
excel save as csv - force text qualifier on every text field Newbie-Don Excel Discussion (Misc queries) 6 April 2nd 23 08:33 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Repeating text in a text box within Excel. fsattar Excel Discussion (Misc queries) 3 December 30th 04 09:57 PM
Turn Text Box 90 degrees Neil Excel Discussion (Misc queries) 1 December 5th 04 04:59 PM


All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"