How does one apply letters with accents (e.g. grave - è, accute - é, etc.) in
MS Excel using shortcuts, like Ctrl+` e, as in MS Word (and not having to
search through Symbol everytime)?

Characters can be created using the =CHAR(Value) function, and using the
function with auto correct will mimic the functionality of Word.

In a blank worksheet, starting in A1, enter the numbers 200 through 203, and
then the numbers 224 through 246. Then in starting in column B1 enter the
following formula:

=CHAR(A1)

Press enter and copy down to the last number in column A.

You now have a reference for you AutoCorrect entries.

Click TOOLS in the menu, select AUTO CORRECT and click the AUTOCORRECT tab
if necessary.

In the replace type e` and in the WITH textbox enter the following formula:

=CHAR(232)

Click the ADD command button and continue adding key combinations and CHAR
formulas until done. Click after completing all the replacement entries.

Hope this helps.

--
Kevin Backmann


"JMAO" wrote:

How does one apply letters with accents (e.g. grave - è, accute - é, etc.) in
MS Excel using shortcuts, like Ctrl+` e, as in MS Word (and not having to
search through Symbol everytime)?

HI JMAO
Just to add to Kevin's reply, you can enter the characters direct by
pressing ALT+0 and the number eg: alt+0233 for é, alt+0232 for è
don't use the numbers above the letters use the num.. keypad.
Regards
Cimjet
PS.. you can use that with Word and most software.
"JMAO" wrote in message
...
How does one apply letters with accents (e.g. grave - è, accute - é, etc.)
in
MS Excel using shortcuts, like Ctrl+` e, as in MS Word (and not having to
search through Symbol everytime)?