I work a lot in Excel, using Chinese PinYin (Chinese words using our letters,
rather than Chinese characters) - where every single word has at least one
character with an accent on it!

In Word 2007, you can assign keyboard shortcuts to enter the relevant letter
- such as an "a" with a grave accent (CRTL+`,a) or with an accute accent
(CRTL+',a). These shortcuts make sense (ie. easy to remember) as they
involve the actual letter + something that's on the keyboard, and you don't
have to go into the Insert Symbol menu/window each time. You can also
assign your own shortcuts to characters that aren't pre-assigned.

In Excel you don't appear to be able to use these. Instead it appears that
the only way to do this is by going into the Insert Symbol menu. This is
very slow!! Even if you pin the menu to your Quick Access Toolbar, it's
still very annoying since you have to switch between keyboard and mouse for
every single word. And you can't leave the window open whilst you continue
with your typing.

Can anyone suggest a way I can assign shortcuts and use them in Excel 2007?
(Preferably these would be the same shortcuts as in Word, as I won't be able
to remember the ALT+0000 number for all the different characters).

Help please!!!

While you can use OnKey to re-define keystrokes, I would make the effort to
search for a font that gives you the proper typography and install it


--
Gary''s Student - gsnu200800


"tyhubb" wrote:

I work a lot in Excel, using Chinese PinYin (Chinese words using our letters,
rather than Chinese characters) - where every single word has at least one
character with an accent on it!

In Word 2007, you can assign keyboard shortcuts to enter the relevant letter
- such as an "a" with a grave accent (CRTL+`,a) or with an accute accent
(CRTL+',a). These shortcuts make sense (ie. easy to remember) as they
involve the actual letter + something that's on the keyboard, and you don't
have to go into the Insert Symbol menu/window each time. You can also
assign your own shortcuts to characters that aren't pre-assigned.

In Excel you don't appear to be able to use these. Instead it appears that
the only way to do this is by going into the Insert Symbol menu. This is
very slow!! Even if you pin the menu to your Quick Access Toolbar, it's
still very annoying since you have to switch between keyboard and mouse for
every single word. And you can't leave the window open whilst you continue
with your typing.

Can anyone suggest a way I can assign shortcuts and use them in Excel 2007?
(Preferably these would be the same shortcuts as in Word, as I won't be able
to remember the ALT+0000 number for all the different characters).

Help please!!!