ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   My Word shortcut keys for Windings won't work in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/177200-my-word-shortcut-keys-windings-wont-work-excel.html)

Mulberry

My Word shortcut keys for Windings won't work in Excel
 
I need to put 'ticks' and 'smiley faces' into cells in Excel 2000. These
characters are in Windings. I set shortcut keys for both characters in Word
but these shortcut keys do not work when in Excel. None of the normal
keystrokes I try in Windings when in Excel will give me these characters.

RagDyeR

My Word shortcut keys for Windings won't work in Excel
 
Format a cell to Wingdings, and just enter an uppercase J for a smiley face.

In Windings2, an upper case P produces a tick.

I mention these because they are single keystrokes.


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mulberry" wrote in message
...
I need to put 'ticks' and 'smiley faces' into cells in Excel 2000. These
characters are in Windings. I set shortcut keys for both characters in
Word
but these shortcut keys do not work when in Excel. None of the normal
keystrokes I try in Windings when in Excel will give me these characters.




Gord Dibben

My Word shortcut keys for Windings won't work in Excel
 
Alt + 0074, 0075 and 0076 are the 3 smiley/frowny/yucky characters..........0252
is the tick

Type the numbers on the Numpad, not the keys above qwerty


Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 14:34:02 -0800, Mulberry
wrote:

I need to put 'ticks' and 'smiley faces' into cells in Excel 2000. These
characters are in Windings. I set shortcut keys for both characters in Word
but these shortcut keys do not work when in Excel. None of the normal
keystrokes I try in Windings when in Excel will give me these characters.



Mulberry

My Word shortcut keys for Windings won't work in Excel
 
Hello, thanks for your help. I was hoping for keystrokes for both characters
in the same font as the entry of ticks and smileys is random and I will have
to format each cell to either windings or windings 2 as I go. Am attempting a
macro on the keystrokes in the other post. Thanks again

"RagDyer" wrote:

Format a cell to Wingdings, and just enter an uppercase J for a smiley face.

In Windings2, an upper case P produces a tick.

I mention these because they are single keystrokes.


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mulberry" wrote in message
...
I need to put 'ticks' and 'smiley faces' into cells in Excel 2000. These
characters are in Windings. I set shortcut keys for both characters in
Word
but these shortcut keys do not work when in Excel. None of the normal
keystrokes I try in Windings when in Excel will give me these characters.





Mulberry

My Word shortcut keys for Windings won't work in Excel
 
Thank you very much, extremely helpful... I now have a macro for each
character but ......... I will sometimes need to enter 2 or more characters
in a cell. I can do this using the keystrokes that you gave me but not with
the maros built on the keystrokes; with the macros the the cell won't take a
second character. Any suggestions. Many thanks

"Gord Dibben" wrote:

Alt + 0074, 0075 and 0076 are the 3 smiley/frowny/yucky characters..........0252
is the tick

Type the numbers on the Numpad, not the keys above qwerty


Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 14:34:02 -0800, Mulberry
wrote:

I need to put 'ticks' and 'smiley faces' into cells in Excel 2000. These
characters are in Windings. I set shortcut keys for both characters in Word
but these shortcut keys do not work when in Excel. None of the normal
keystrokes I try in Windings when in Excel will give me these characters.




Gord Dibben

My Word shortcut keys for Windings won't work in Excel
 
Suggestions?

Nothing comes to mind that will let you stick multiple smilies or ticks without
a specific macro.


Gord

On Tue, 19 Feb 2008 21:25:00 -0800, Mulberry
wrote:

Thank you very much, extremely helpful... I now have a macro for each
character but ......... I will sometimes need to enter 2 or more characters
in a cell. I can do this using the keystrokes that you gave me but not with
the maros built on the keystrokes; with the macros the the cell won't take a
second character. Any suggestions. Many thanks

"Gord Dibben" wrote:

Alt + 0074, 0075 and 0076 are the 3 smiley/frowny/yucky characters..........0252
is the tick

Type the numbers on the Numpad, not the keys above qwerty


Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 14:34:02 -0800, Mulberry
wrote:

I need to put 'ticks' and 'smiley faces' into cells in Excel 2000. These
characters are in Windings. I set shortcut keys for both characters in Word
but these shortcut keys do not work when in Excel. None of the normal
keystrokes I try in Windings when in Excel will give me these characters.






All times are GMT +1. The time now is 09:10 AM.

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