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)?