Hi,
Is it possible to invert text by 180 deg. Under Format - cells you only have the option of 90 deg.
Hi,
Is it possible to invert text by 180 deg. Under Format - cells you only have the option of 90 deg.
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 <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
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 <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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
> >
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks