Using Accented Characters In Excel

Adding accented characters into your Excel workbook is commonly achieved by using the Insert –> Symbol menu options to select the character you want, however while this is fine for inserting the odd symbol every now and again, if you have to enter lots of different symbols then things can become very tedious indeed.

Fortunately Microsoft have provided a fairly quick and easy method to enter the common accented characters by remembering a few shortcuts. It is possible to enter an accented character by one of two methods:

  1. By holding down the ‘Alt’ and ‘Ctrl’ keys, and then pressing the letter on the keyboard you want accented.
  2. By holding down the ‘Alt’ key and typing a number code on the numeric keypad.

 

Below is a table showing the most commonly used characters, just remember that when entering numbers you need to use the numeric keypad.

á Ctrl+Alt+a Á Ctrl+Alt+A
é Ctrl+Alt+e É Ctrl+Alt+E
í Ctrl+Alt+i Í Ctrl+Alt+I
ó Ctrl+Alt+o Ó Ctrl+Alt+O
ú Ctrl+Alt+u Ú Ctrl+Alt+U
à Alt+0224 À Alt+0192
è Alt+0232 È Alt+0200
ì Alt+0236 Ì Alt+0204
ò Alt+0242 Ò Alt+0210
ù Alt+0249 Ù Alt+0217
â Alt+0226 Â Alt+0194
ê Alt+0234 Ë Alt+0203
î Alt+0238 Î Alt+0206
ô Alt+0244 Ô Alt+0212
û Alt+0251 Û Alt+0219