ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shorttcut key for entering suit symbols in Microsoft Excel (https://www.excelbanter.com/excel-discussion-misc-queries/231082-shorttcut-key-entering-suit-symbols-microsoft-excel.html)

Bud H

Shorttcut key for entering suit symbols in Microsoft Excel
 
In Microsoft Word, it is easy to make a shortcut key for each of the four
suit symbols. For example, I use Alt+S, Alt+H, Alt+D, and Alt+C to enter
suit symbols in Word 2003.

However, In Microsoft Excel 2003, there is no obvious shortcut key to choose
for the special symbols. It appears you would have to use Insert--Symbol
to enter a suit symbol, which is far less convenient.

Is there any way to create a shortcut key or combination of keystrokes for
each suit symbol? (Even better if the heart and diamond symbols came out in
red.)

Bud H



Gord Dibben

Shorttcut key for entering suit symbols in Microsoft Excel
 
Format the cells as Symbol font.

Alt + 0167 through 170 will produce the 4 suits.

Format diamonds and hearts to red font.


Gord Dibben MS Excel MVP

On Sun, 17 May 2009 11:26:30 -0400, "Bud H" wrote:

In Microsoft Word, it is easy to make a shortcut key for each of the four
suit symbols. For example, I use Alt+S, Alt+H, Alt+D, and Alt+C to enter
suit symbols in Word 2003.

However, In Microsoft Excel 2003, there is no obvious shortcut key to choose
for the special symbols. It appears you would have to use Insert--Symbol
to enter a suit symbol, which is far less convenient.

Is there any way to create a shortcut key or combination of keystrokes for
each suit symbol? (Even better if the heart and diamond symbols came out in
red.)

Bud H



Bud H

Shortcut key for entering suit symbols in Microsoft Excel
 
On my laptop computer, if I push Alt and start typing numbers, it simply
beeps at me.



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Format the cells as Symbol font.

Alt + 0167 through 170 will produce the 4 suits.

Format diamonds and hearts to red font.


Gord Dibben MS Excel MVP

On Sun, 17 May 2009 11:26:30 -0400, "Bud H" wrote:

In Microsoft Word, it is easy to make a shortcut key for each of the four
suit symbols. For example, I use Alt+S, Alt+H, Alt+D, and Alt+C to enter
suit symbols in Word 2003.

However, In Microsoft Excel 2003, there is no obvious shortcut key to
choose
for the special symbols. It appears you would have to use Insert--Symbol
to enter a suit symbol, which is far less convenient.

Is there any way to create a shortcut key or combination of keystrokes for
each suit symbol? (Even better if the heart and diamond symbols came out
in
red.)

Bud H





Gord Dibben

Shortcut key for entering suit symbols in Microsoft Excel
 
Don't have a laptop but I believe you have to use some other key like an Fn
key or something.


Gord

On Sun, 17 May 2009 20:31:46 -0400, "Bud H" wrote:

On my laptop computer, if I push Alt and start typing numbers, it simply
beeps at me.



"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Format the cells as Symbol font.

Alt + 0167 through 170 will produce the 4 suits.

Format diamonds and hearts to red font.


Gord Dibben MS Excel MVP

On Sun, 17 May 2009 11:26:30 -0400, "Bud H" wrote:

In Microsoft Word, it is easy to make a shortcut key for each of the four
suit symbols. For example, I use Alt+S, Alt+H, Alt+D, and Alt+C to enter
suit symbols in Word 2003.

However, In Microsoft Excel 2003, there is no obvious shortcut key to
choose
for the special symbols. It appears you would have to use Insert--Symbol
to enter a suit symbol, which is far less convenient.

Is there any way to create a shortcut key or combination of keystrokes for
each suit symbol? (Even better if the heart and diamond symbols came out
in
red.)

Bud H






All times are GMT +1. The time now is 04:01 AM.

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