Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,646
Default keyboard shortcut for Σ symbol?

tHi All,

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

Regards,
Stefi
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 36
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default keyboard shortcut for Σ symbol?

Alt+=

"Stefi" wrote:

tHi All,

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

Regards,
Stefi

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,646
Default 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





  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 36
Default 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"


  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,646
Default 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"



  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 751
Default 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"




  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 36
Default 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).


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
Keyboard Shortcut for More/Less Decimals JonOfAllTrades Excel Discussion (Misc queries) 4 June 15th 06 05:11 PM
Keyboard Shortcut for Zooming Henrik Excel Worksheet Functions 1 February 4th 06 08:54 PM
Keyboard shortcut not working when I copy macro to another computer telewats New Users to Excel 1 January 9th 06 08:52 PM
Isolating a Keyboard Shortcut RWN Setting up and Configuration of Excel 1 October 23rd 05 09:55 PM
keyboard shortcut Aditya Excel Worksheet Functions 1 February 21st 05 01:34 PM


All times are GMT +1. The time now is 08:02 PM.

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"