LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default POSSIBLE TO ROTATE FONTS 180% ?

The only way I know is to use some code. I assume that you want
Type Words in Reverse
to appear as
esreveR ni sdroW epyT

Here's the code to accomplish that - pretty much only works for non Word
wrapped cells (or reverse before applying word wrap). Press [Alt]+[F11] to
get to the VB Editor, use Insert | Module to create a code module, then copy
and paste the code below into it.

Sub ReverseText()
'works with current selection
Dim anyGroup As Range
Dim anyCell As Range
Dim tmpText As String
Dim revText As String
Dim LC As Integer

Set anyGroup = Selection
For Each anyCell In anyGroup
revText = ""
tmpText = anyCell.Text
If Len(tmpText) 0 Then
For LC = Len(tmpText) To 1 Step -1
revText = revText & Mid(tmpText, LC, 1)
Next
anyCell = revText
End If
Next
End Sub

If you want true mirror image of the text, you'd need to create mirrored
font set. If you look closely at the above, you'll notice that the openings
of non-symmetrical characters like e, s, p and d are not reversed. There are
tools that can be used to create new font sets or modify existing ones. I've
successfully used a program called FontCreator to modify existing fonts for
this mirroring. Contact me if you want to try one or two (remove spaces):
HelpFrom @ jlathamsite.com There are copyright issues involved, so any that
you wish to use must also exist and be licensed to you for use on the system.
I haven't researched this in depth, but I would think that fonts provided
with your operating system would meet the requirements.

"J.J." wrote:

I AM USING AN EXCEL SPREADSHEET AND WOULD LIKE TO POST FONTS AT 180%. OF
COURSE I CAN USE THEM AT 90% BUT HAVE NOT FIGURED OUT THE SECRET OF THE 180%
PLEASE HELP.........THANKS IN ADVANCE

 
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
How do i rotate data - see below AdrianCoyte Excel Discussion (Misc queries) 6 March 21st 07 09:10 PM
How can I lengthen the drop down Fonts list to show more fonts at Moser D Excel Discussion (Misc queries) 1 February 5th 06 03:24 PM
Rotate textbox Pat Excel Discussion (Misc queries) 1 April 12th 05 01:13 PM
How do I rotate a text box Kent Charts and Charting in Excel 2 December 17th 04 12:13 AM
How I do I rotate text in an excel cell? The rotate commands is g. MickG Excel Discussion (Misc queries) 3 December 13th 04 08:14 PM


All times are GMT +1. The time now is 06:14 PM.

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

About Us

"It's about Microsoft Excel"