How does one apply letters with accents

[JMAO]

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

 

[Kevin B]

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.

 

[Cimjet]

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.