Thread
:
what is the shortcut for 1/2 using the Alt button ?
View Single Post
#
5
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
what is the shortcut for 1/2 using the Alt button ?
Or just autofill numbers in col A and in col b =char(a2) and copy down. Then
you have the num & char.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Ragdyer" wrote in message
...
I think it's much better to "roll your own" when it comes to something like
this.
Make your own character chart!
On a blank sheet, enter this in A33:
=Char(Row())
And drag across, say 5 or 6 columns.
Then drag that selection down to Row255.
This will give you a display of the Char values from 33 to 255,
which you can easily identify by simply looking at the row number.
Values below (less then) 33 are usually not needed.
Now, scroll up so that Row32 is at the *top* of your screen.
Click in A33, and from the Menu Bar,
<Window <Freeze Panes
This will "lock" Row32 at the top of your screen when scrolling.
In A32 enter the font you're presently using, probably Ariel.
Select Column B and change the font to, say, WingDings.
Select Column C and change the font to, say, WingDings2.
Enter the name of the font you chose into Row32 of the appropriate column.
You can now see and compare results side by side.
Char(74) in WingDings displays a funny face <Alt074
Char(80) in Wingdings2 displays a check (tick) mark <Alt080
*BUT*, you can also see, from your home made chart, that Char(74) in Ariel
is an upper case "J",
so ... format a cell to WingDings, and just hit a capitol J to display
that
funny face,
OR
a capitol P to display a check mark in WingDings2.
You can apply different fonts to a range of your columns and compare the
displays of as many fonts as you please in this chart.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jacob Skaria" wrote in message
...
The below link will be helpful.
http://www.autohotkey.com/forum/topic13149.html
--
If this post helps click Yes
---------------
Jacob Skaria
"hbmonrny" wrote:
what is the shortcut for 1/2 using the Alt button ?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett