Can I assign keyboard shortcuts for special characters in Excel 20

T

tyhubb

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!!!
 
G

Gary''s Student

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
 

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