How to Translate Text in Excel 2010
Speeding Data Entry with Excel 2010's AutoFill Feature
Automatically Fix Typos and Add Text with AutoCorrect in Excel 2010

How to Insert Symbols and Special Characters in Excel 2010

Excel 2010 makes it easy to enter symbols, such as foreign currency marks, as well as special characters, like trademark and copyright symbols, into cells. These symbols are available in the Symbol dialog box. To add a special symbol or character to a cell entry, follow these steps:


Click the Insert tab and then click the Symbol button in the Symbols group.

The Symbol dialog box appears. The Symbol dialog box contains two tabs: Symbols and Special Characters.


(Optional) Click the Font drop-down list button and select a different font.

Check out the Wingdings and Webdings fonts to see a wide variety of symbols that you won't find with most other common fonts.


(Optional) Click the Subset drop-down list button and select the desired character set.

These subsets include foreign alphabets, accented characters, and mathematical operators.


Select the desired symbol on the Symbols tab; or click the Special Characters tab and select the desired character.

Notice that the most recently used symbols appear near the bottom of the Symbols tab.


Click Insert to insert the symbol or character.

The Symbol dialog box stays open so you can insert a string of special characters without having to re-open the dialog box for each one. Repeat steps 2 through 5 for each character or symbol you want to insert.


Click Close when you're done adding symbols and special characters.

The inserted symbols or characters appear in the worksheet.


Press Enter to complete the cell entry.

If you need to add more (regular) text to the cell entry, you can continue typing after you click Close and before you press Enter.

blog comments powered by Disqus
How to Use Excel 2010's Research Task Pane
How to Create a New Custom Dictionary in Excel 2010
How to Drag and Drop Data in Excel 2010
How to Use the Thesaurus in Excel 2010
How to Edit Records in an Excel 2010 Table