what is the shortcut for 1/2 using the Alt button ?

  • Thread starter Thread starter hbmonrny
  • Start date Start date
<Alt>0189
using the numbers from the num keypad, *not* the numbers under the function
keys.
 
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 <Alt>074
Char(80) in Wingdings2 displays a check (tick) mark <Alt>080

*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.
 
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 <Alt>074
Char(80) in Wingdings2 displays a check (tick) mark <Alt>080

*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.
 
Or just autofill numbers in col A and in col b =char(a2) and copy down. Then
you have the num & char.
 
Or just autofill numbers in col A and in col b =char(a2) and copy down. Then
you have the num & char.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top