Shorttcut key for entering suit symbols in Microsoft Excel

B

Bud H

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
 
G

Gord Dibben

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
 
B

Bud H

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

Gord Dibben

Don't have a laptop but I believe you have to use some other key like an Fn
key or something.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top