ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   keyboard shortcut for Σ symbol? (https://www.excelbanter.com/excel-worksheet-functions/118592-keyboard-shortcut-%CE%A3-symbol.html)

Stefi

keyboard shortcut for Σ symbol?
 
tHi All,

Is there a keyboard shorcut for entering a Σ symbol, e.g. Alt+????

Regards,
Stefi

Andy Brown

keyboard shortcut for S symbol?
 
"Stefi" wrote in message
...
tHi All,

Is there a keyboard shorcut for entering a ? symbol, e.g. Alt+????


Don't think so. An upper case "S" in Symbol font should do it.



Teethless mama

keyboard shortcut for Σ symbol?
 
Alt+=

"Stefi" wrote:

tHi All,

Is there a keyboard shorcut for entering a Σ symbol, e.g. Alt+????

Regards,
Stefi


Gord Dibben

keyboard shortcut for ? symbol?
 
ALT + 0063

On the NumPad.


Gord Dibben MS Excel MVP

On Mon, 13 Nov 2006 04:25:01 -0800, Stefi
wrote:

tHi All,

Is there a keyboard shorcut for entering a ? symbol, e.g. Alt+????

Regards,
Stefi



Stefi

keyboard shortcut for ? symbol?
 
Hi Teethless mama and Gord,
Thanks for your replies but Alt+= doesn't do anything for me. I use XL2003
Hungarian version, default font is Arial.
Alt+0063 gives a ?. The interesting thing is that when I insert Σ via
Insert/Symbols(Font:Normal text, character code:03A3, character
set:Unicode/hexadecimal), a Σ is displayed in the cell, the CODE function
returns 63, the cell's font remains Arial.
When I type in a ? it is displayed as ? and CODE is 63.
Any ideas?

Regards,
Stefi

Gord Dibben ezt *rta:

ALT + 0063

On the NumPad.


Gord Dibben MS Excel MVP

On Mon, 13 Nov 2006 04:25:01 -0800, Stefi
wrote:

tHi All,

Is there a keyboard shorcut for entering a ? symbol, e.g. Alt+????

Regards,
Stefi




Andy Brown

keyboard shortcut for ? symbol?
 
"Stefi" wrote in message
...
Hi Teethless mama and Gord,
Thanks for your replies but Alt+= doesn't do anything for me. I use XL2003
Hungarian version, default font is Arial.
Alt+0063 gives a ?. The interesting thing is that when I insert ? via
Insert/Symbols(Font:Normal text, character code:03A3, character
set:Unicode/hexadecimal), a ? is displayed in the cell, the CODE function
returns 63, the cell's font remains Arial.
When I type in a ? it is displayed as ? and CODE is 63.
Any ideas?


I wouldn't know about Insert Symbol, I'm on Excel 2000. If you need a
shorter cut, you could try a macro assigned to a custom toolbar button:

ActiveCell = "S": ActiveCell.Font.Name = "Symbol"



Stefi

keyboard shortcut for ? symbol?
 
Thanks Andy, it works!
I still am interested in the question in my previous post (how can I enter a
Capital Greek Letter Sigma via keyboard, e.g. Alt+something?)

Regards,
Stefi

Andy Brown ezt *rta:

"Stefi" wrote in message
...
Hi Teethless mama and Gord,
Thanks for your replies but Alt+= doesn't do anything for me. I use XL2003
Hungarian version, default font is Arial.
Alt+0063 gives a ?. The interesting thing is that when I insert ? via
Insert/Symbols(Font:Normal text, character code:03A3, character
set:Unicode/hexadecimal), a ? is displayed in the cell, the CODE function
returns 63, the cell's font remains Arial.
When I type in a ? it is displayed as ? and CODE is 63.
Any ideas?


I wouldn't know about Insert Symbol, I'm on Excel 2000. If you need a
shorter cut, you could try a macro assigned to a custom toolbar button:

ActiveCell = "S": ActiveCell.Font.Name = "Symbol"




vezerid

keyboard shortcut for ? symbol?
 
Stefi,

Have you tried to add the Greek keyboard to your computer? Sigma is
readily available as capital S. In this case you would need just the
combination Alt+Shift enough times to use Greek (probably cumbersome,
but just my 2 cents worth...)

HTH
Kostis


Stefi wrote:
Thanks Andy, it works!
I still am interested in the question in my previous post (how can I enter a
Capital Greek Letter Sigma via keyboard, e.g. Alt+something?)

Regards,
Stefi

,,Andy Brown" ezt rta:

"Stefi" wrote in message
...
Hi Teethless mama and Gord,
Thanks for your replies but Alt+= doesn't do anything for me. I use XL2003
Hungarian version, default font is Arial.
Alt+0063 gives a ?. The interesting thing is that when I insert ? via
Insert/Symbols(Font:Normal text, character code:03A3, character
set:Unicode/hexadecimal), a ? is displayed in the cell, the CODE function
returns 63, the cell's font remains Arial.
When I type in a ? it is displayed as ? and CODE is 63.
Any ideas?


I wouldn't know about Insert Symbol, I'm on Excel 2000. If you need a
shorter cut, you could try a macro assigned to a custom toolbar button:

ActiveCell = "S": ActiveCell.Font.Name = "Symbol"





Andy Brown

keyboard shortcut for ? symbol?
 
"Stefi" wrote in message
...
Thanks Andy, it works!
I still am interested in the question in my previous post (how can I enter
a
Capital Greek Letter Sigma via keyboard, e.g. Alt+something?)


If you're desperate for a keyboard method, define a shortcut key for the
macro -- CTRL+Shift+E perhaps -- and store the macro in your personal macro
workbook (so that it's available whenever you run Excel).




All times are GMT +1. The time now is 03:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com