View Single Post
  #3   Report Post  
Gary's Student
 
Posts: n/a
Default

Text can be rotated to any desired angle.

Select the text as shown on the worksheet (not just the first cell). While
holding down the SHIFT key, pulldown Edit and click Copy Picture. Click As
Shown on the Screen and Picture.

Select another place on your worksheet and paste.

The result is a picture. You can move it anywhere, re-size it, and rotate it.

Good Luck


--
Gary's Student


"R.VENKATARAMAN" wrote:

from my archives
sometime back i used this formula
=OFFSET($B$1,MATCH($B$16,B1:B16,0)-1,0)


my original data is in B1 to B16
I copied this to any cell and copy down

try this.
may be easier solutions available




tryer wrote in message
...

Hi,

Is it possible to invert text by 180 deg. Under Format - cells you only
have the option of 90 deg.


--
tryer
------------------------------------------------------------------------
tryer's Profile:

http://www.excelforum.com/member.php...o&userid=16546
View this thread: http://www.excelforum.com/showthread...hreadid=399793