The procedures listed below must be followed in order to insert or enter letters with accent marks in Microsoft Excel for users without special keyboards.
Adding accented letters through the Ribbon or menu bar
- Open Excel.
- Either click Insert in the menu bar or select the Insert tab on the Ribbon.
- Choose the Symbol choice from the Insert drop-down or the Insert tab.
- From the list of symbols, pick the accented character or symbol you want.
To display a particular sort of symbol, choose from the Subset drop-down list or browse through the complete list.
For a longer list of insertable symbols in Excel 2003 and prior versions, select the More Symbols option.
- Click the Insert button after choosing the desired accented letter or symbol.
Once a character has been added using the aforementioned procedures to insert an accented character, you may duplicate that character and paste it into another location within the worksheet.