For users who do not have specialized keyboards, letters with accent marks must be inserted or entered in Microsoft Excel using the steps below.
Inserting accented letters with the menu bar or Ribbon
For the Mac, there's a huge variety of built-in keyboard layouts, but non-default choices have to be selected – otherwise there would be huge clutter and confusion. But it's very easy to use once you get the hang of it, and incredibly powerful. To get a range of accent marks (e.g. For Pinyin), I use the 'U.S. Extended' layout. You can use your computer keyboard or mouse to type Vietnamese letters with this online keyboard. Pressing Esc on the Vietnamese keyboard layout will toggle the mouse input between virtual QWERTY keyboard and virtual Vietnamese keyboard. The key will also turn on/off your keyboard input conversion. ALT codes for Maltese letters with accents. Below is the complete list of Windows ALT key numeric pad codes for Latin letters with accents or diacritical marks that are used in the Maltese alphabet. If you are new to ALT codes and need detailed instructions on how to use them, please read How to Use ALT Codes to Enter Special Characters. Click on the default button will reset all the settings on this 'Keyboard Options' dialog to the default state, which supports typing Vietnamese only, together with the capability of using fast accent marks. Cancel button: Click on the cancel button will discard all the changes you have made so far on this 'Keyboard.
- Open Microsoft Excel.
- Select the Insert tab on the Ribbon or click Insert in the menu bar.
- On the Insert tab or the Insert drop-down, select the Symbol option.
- Select the desired accented character or symbol from the list of symbols. You can scroll through the entire list or select from the Subset drop-down list to view a specific type of symbols.
In Excel 2003 and earlier versions, you can click the More Symbols option to see a larger list of available symbols to insert.
- After selecting the desired accented letter or symbol, click the Insert button.
If you insert an accented character using the steps above, once a character is inserted, you can copy that character and paste it anywhere else in the worksheet.
Additional information
International Keyboard Codes | Windows Character Map | Mac Accent Codes
This page list codes for accented letters and other characters. In order to use these codes, your computer should have a separate numeric keypad on the right. If it does not, then another method of inputting accents is recommended.
Page Content
For information on how to type the codes, please read the detailed instructions.
- Letters with Accents – (e.g.ó, ò, ñ)
- Other Foreign Characters – (e.g. ç, ¿, ß)
- Currency Symbols – (e.g. ¢, £, ¥)
- Math Symbols – (e.g. ±, °, ÷)
- Other Punctuation – (e.g. &, ©, §)
- Other Accents and Symbols:Character MapOther Page
- Non-Numeric Accent Codes:Activate International KeyboardOther Page
Letters with Accents
This list is focused on Western European languages. See the individual Language pages for additional codes.
Accent | A | E | I | O | U | Y |
---|---|---|---|---|---|---|
Grave Capital | À 0192 | È 0200 | Ì 0204 | Ò 0210 | Ù 0217 | -- |
Grave Lower Case | à 0224 | è 0232 | ì 0236 | ò 0242 | ù 0249 | -- |
Acute Capital | Á 0193 | É 0201 | Í 0205 | Ó 0211 | Ú 0218 | Ý 0221 |
Acute Lower Case | á 0225 | é 0233 | í 0237 | ó 0243 | ú 0250 | ý 0253 |
Circumflex Capital | Â 0194 | Ê 0202 | Î 0206 | Ô 0212 | Û 0219 | -- |
Circumflex Lower Case | â 0226 | ê 0234 | î 0238 | ô 0244 | û 0251 | -- |
Tilde Capital | Ã 0195 | -- | Ñ 0209 | Õ 0213 | — | -- |
Tilde Lower Case | ã 0227 | -- | ñ 0241 | õ 0245 | — | -- |
Umlaut Capital | Ä 0196 | Ë 0203 | Ï 0207 | Ö 0214 | Ü 0220 | Ÿ 0159 |
Umlaut Lower Case | ä 0228 | ë 0235 | ï 0239 | ö 0246 | ü 0252 | ÿ 0255 |
Example
To input the acute a á (0225), hold down the ALT key, type 0225 on the numeric keypad, then release the ALT key.
If you are having problems inputting these codes, please review the instructions for using the codes at the bottom of this Web page.
Additional Codes
See the Specific Language Page for additional codes for accented characters. Note that codes may only work in Microsoft Office.
Other Foreign Characters
SYMBOL | NAME | CODE NUMBER |
---|---|---|
¡ | Upside-down exclamation mark | 0161 |
¿ | Upside-down question mark | 0191 |
Ç, ç | French C cedille (caps/lowecase) | 0199 0231 |
Œ,œ | O-E ligature (caps/lowecase) | 0140 0156 |
ß | German Sharp/Double S | 0223 |
º, ª | Masculine Ordinal Number (Span/Ital/Portuguese) Feminine Ordinal Number | 0186 0170 |
Ø,ø | Nordic O slash (caps/lowecase) | 0216 0248 |
Å,å | Nordic A ring (caps/lowecase), Angstrom sign | 0197 0229 |
Æ, æ | A-E ligature (caps/lowecase) | 0198 0230 |
Þ, þ | Icelandic/Old English Thorn (caps/lowecase) See other Old English Characters | 0222 0254 |
Ð, ð | Icelandic/Old English Eth (caps/lowecase) | 0208 0240 |
« » | Spanish/French angle quotation marks | 0171 0187 |
‹ › | Spanish/French angle single quotation marks | 0139 0155 |
Š š | Czech S hachek (S Caron) (caps/lowercase) See other Czech Characters | 0138 0154 |
Ž ž | Czech Z hachek (Z Caron) (caps/lowercase) | 0142 0158 |
Currency Symbols
SYMBOL | NAME | CODE NUMBER |
---|---|---|
¢ | Cent sign | 0162 |
£ | British Pound | 0163 |
€ | Euro currency | 0128 |
¥ | Japanese Yen | 0165 |
ƒ | Dutch Florin | 0131 |
¤ | Generic currency symbol | 0164 |
Math Symbols
SYMBOL | NAME | CODE NUMBER |
---|---|---|
÷ | Division sign | 0247 |
° | Degree symbol | 0176 |
¬ | Not symbol | 0172 |
± | Plus/minus | 0177 |
µ | Micro | 0181 |
‰ | Per Mille (1/1000th) | 0137 |
Fractions
These codes produce fractions which are spaced on one line.
SYMBOL | NAME | CODE NUMBER |
---|---|---|
¼ | Fraction 1/4 | 0188 |
½ | Fraction 1/2 | 0189 |
¾ | Fraction 3/4 | 0190 |
Superscript and Subscript
Check these references for other methods to implement superscript/subscript and extra fractions
Additional Math Codes
See the Unicode Math Chart for additional codes for math symbols. Note that they only work in Microsoft Office and that you should use the non-Hex code. For instance an entry ∛ for the cube root symbol (∛) would correspond to ALT+8731 in Word.
Other Punctuation
These incude copyright symbols and special section marks.
SYMBOL | NAME | CODE NUMBER |
---|---|---|
© | Copyright symbol | 0169 |
® | Registered symbol | 0174 |
™ | Trademark | 0153 |
• | List Dot | 0149 |
§ | Section Symbol | 0167 |
† | Dagger | 0134 |
‡ | Double Dagger | 0135 |
– | en-dash | 0150 |
-- | em-dash | 0151 |
¶ | Paragraph Symbol (Pilcrow) | 0182 |
Using the Codes
Windows assigns a numeric code to different accented letters, other foreign characters and special mathematical symbols. For instance the code for lower case á is 0225, and the code for capital Á is 0193. The ALT key input is used to manually insert these letters and symbols by calling the numeric code assigned to them.
Vietnamese Keyboard Online LEXILOGOS
To Use the Codes
Cached
- Place your cursor in the location where you wish to insert a special character.
- Activate the numeric key pad on the right of the keyboard by pressing Num Lock (upper right of keyboard). The Num Lock light on the keyboard will indicate that the numeric key pad is on.
NOTE: You must use the numeric key pad; if you use the number keys on the top of the keyboard, the characters will not appear. If you are on a laptop or computer without a separate numeric keypad one of the other methods is recommended. - While pressing down the ALT key, type the four-digit code on the numeric key pad at the right edge of the keyboard. The codes are 'case sensitive.' For instance, the code for lower-case á is ALT+0225, but capital Á is ALT+0193.
NOTE: If you have the International keyboard activated, you will only be able to input codes with the ALT key on the left side of the keyboard. - Release the ALT key. The character will appear when the ALT key is released.
NOTE: You must include the initial zero in the code. For example to insert á(0225) you must type ALT+0225, NOT ALT+225.