Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default what is the shortcut for 1/2 using the Alt button ?

what is the shortcut for 1/2 using the Alt button ?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default what is the shortcut for 1/2 using the Alt button ?

<Alt0189
using the numbers from the num keypad, *not* the numbers under the function
keys.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"hbmonrny" wrote in message
...
what is the shortcut for 1/2 using the Alt button ?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default what is the shortcut for 1/2 using the Alt button ?

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 ?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default what is the shortcut for 1/2 using the Alt button ?

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 ?


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default 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
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
Shortcut menu won't appear when I click right mouse button. jngrant28 Excel Discussion (Misc queries) 3 June 17th 08 05:23 PM
Button / Shortcut to extranal file's macro? Andrew Excel Discussion (Misc queries) 3 June 12th 08 10:37 PM
TOOLBAR button or Keyboard Shortcut FOR Center Across Selection?? RajenRajput1 Excel Discussion (Misc queries) 13 April 29th 08 07:30 PM
Save button-shortcut mhanley Excel Worksheet Functions 0 November 8th 06 03:13 PM
Shortcut Keystroke for the AutoSum button or Sum function? L Lightner Excel Discussion (Misc queries) 2 July 19th 06 12:56 AM


All times are GMT +1. The time now is 02:41 AM.

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

About Us

"It's about Microsoft Excel"