Keyboard Shortcuts for Greek Letters 5

[MattGreer]

OK, so I use character map to find these things. For the greek letter rho, in the Calibri font, the code reads "U+03C1".

I was used to typing "alt codes" to achieve these things, for example, to get the degree symbol °, I hold down the alt key and type "0176" on the number keypad. This way, I don't have to go searching through the character map and I can just have a shortcut written down on my desk for such things.

Is there a way to translate "U+03C1" to an "alt code"?


Thanks!!


Matt

 

[AnotherHiggins]

See this explanation of how to insert ASCII characters into Excel using the [Alt] key:

http://office.microsoft.com/en-us/excel/HA011331361033.aspx

As you'll see, Rho isn't available.

But if you change the font to Symbol, then you can just use r or R to produce the lower or upper case of Rho.

If you want to display Rho along with non-greek characters in a single cell, then you can select the R in the formula bar and just change the font for that single character.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[fumei]

And, exactly, how do you know this is a question regarding Excel? Just joshin' ya.

Type: 03C1, Alt-X

This = Unicode 03C1

03a1 will give the capital Rho in Calibri. You do not need to actually use the capitals (C, c, A, a - it does not matter).

The shortcut key shows on the Symbols dialog ("03C1, Alt-X") when - but only when - you have the from: dropdown set to Unicode(hex).

?

0643, Alt-X....I have no idea what it says.

"A little piece of heaven
without that awkward dying part."

advertisment for Reese's Peanut Butter Cups (a chocolate/peanut butter confection)

Gerry

 

[MattGreer]

I'm not really sure I understand, fumei. I saw that instruction out there on the web, but it doesn't work for me in Excel (yep, this is in Excel, but I figured it would apply regardless of the MS product, perhaps I'm wrong).

I type 03C1, and then hit Alt-X, and nothing happens to the cell. The cursor is still in that cell and the cell is still being edited. When I thit the ALT-X the ribbon changes to the Add-Ins menu.

I tried hitting "enter" before hitting ALT-X, but still no joy.

What am I doing wrong? I even tried it with the comma.

I'm not sure I understand what you're talking about regarding the "dropdown set to Unicode(hex)". What is that?

Thanks!!


Matt

 

[fumei]

Well slap me silly (with humble apologies to anotherhiggins!). I am showing my Word bias. You are correct, 03C1, Alt-X does NOT work in Excel (but does in Word).

Further, there is no "Keyboard shortcut 03C1, Alt-X" on the Insert Symbol dialog...but there is in Word.

but I figured it would apply regardless of the MS product, perhaps I'm wrong)

You are wrong.


And so am I!

Sorry, it appears that this shortcut functionality is not included in Excel. I just tried. Nope.

"A little piece of heaven
without that awkward dying part."

advertisment for Reese's Peanut Butter Cups (a chocolate/peanut butter confection)

Gerry

 

[MattGreer]

Thanks anyway! I know how to accomplish what I need, I was just hoping for a shortcut.

Have a good weekend!

Thanks!!


Matt

 

[TonyJollans]

It is possible to use Alt to enter hexadecimal values of Unicode characters, but it needs a registry tweak. The value is:

[blue][tt] HKCU\Control Panel\InputMethod\EnableHexNumpad[/tt][/blue]

If it doesn't exist, create it as String (REG_SZ) value.

Set the (value of the Value) to "1", and reboot.

Now you can press and hold Alt and enter Num+ followed by the hex value (in this case 03C1) using the main keyboard and the numbers from the main keyboard, not the numeric keypad. When you release the Alt key, you should get your character, in this case [blue]?[/blue]

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[fumei]

That deserves a star. Never knew that.

"A little piece of heaven
without that awkward dying part."

advertisment for Reese's Peanut Butter Cups (a chocolate/peanut butter confection)

Gerry

 

[DaveInIowa]

Would it be helpful to map these symbols to AutoCorrect Options? Then use something like:
?rho and ?degree to map to the rho and degree symbols?
Since "03c1" is obscure enough that it wouldn't be found in everyday data entry, you could even map the rho symbol to that series of characters.

 

[GlennUK]

Hi Tony,

I never knew about EnableHexNumpad, ===> *




Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[MakeItSo]

Once more, Tony, you amaze me. ***
I never knew that. This is veeery helpful!


[navy]"We had to turn off that service to comply with the CDA Bill."[/navy]
- The Bastard Operator From Hell

 

[TonyJollans]

Thanks, chaps.

Looking at my post, I see a small typo ...

The registry key is actually [blue][tt]...\Input Method\...[/tt][/blue] - that is there is a space between the two words. I think the "Input Method" key will always exist (just not the EnableHexNumpad value) and you shouldn't have to create a new key to put it in.

FWIW, I just checked and it still works in Windows 7 (not that I had any reason to think it wouldn't).

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website