Microsoft Excel 2007 tutorial: insert symbol or special character

Insert a symbol or special character

XXV. Insert a symbol or special character

You may want to decorate your worksheet to look nicer, more attractive or make the cell contents easier to read by inserting the symbol from the Symbol dialog box. From the dialog box, you can insert the symbol such as wingdings:86 (V) or check mark () or special character such as copyright sign (©) or  register sign (®) that your keyboard does not have.

The symbols types and characters types that you insert base on the font that you select. For instance, some fonts such as Arial, Tahoma, and Timer New Roman include fractions (¼, ½, ¾),  international characters (Í, Ê), business signs (©, ®), international monetary symbols (¢, £, ¥) and so on. The additional fonts including Webdings and Wingdings contain the frequently used symbols and decorative symbols that you might be needed in your work.

To insert a symbol or special character, do the following:

- On the worksheet, click where you want to insert the symbol or special character.

- On the Insert tab, in the Text group, click Symbol button

The Symbol dialog box appears.

Excel 2007 Symbol dialog box

This dialog box has two tabs (Symbols and Special Characters) and two buttons (Insert and Cancel).

The Symbols tab consists of the Font combo box, Subset combo box, Symbol list, Recently used symbols list, Description label , Character code text box, and from combo box.

Font combo box:  It contains a set of font names that you can choose from the box. When you select any font in the box,  the Symbol list will display the symbols basing on the selected font.

Subset combo box: This box can be display when you select the extended font. Otherwise, it disappears. It specifies the subset of special characters of an extended list of language characters including Greek or Russian (Cyrillic), or Mathematical  Operators.

Symbol list: It displays the full list of symbols depending on the selected Font and its Subset.

Recently used symbols list: It displays the most frequently used symbols that you inserted.

Description label: Shows the name of the selected symbol. For example, if you click ¢, the description will display as CENT SIGN.

Character code text box:  Displays input of a unique code of the symbol you selected.

from combo box: States the character set that the character code is based on.  Unicode is a character-encoding standard that enables almost all of writing languages in the world representing a single character set. Unicode use more than one byte to represent each character. ASCII is a character-encoding standard which bases on the English alphabet.

When you click the Special Characters tab, you will see the list that lists the special characters and its description.

For the Insert button is used to insert the symbol that you selected. If you don't want to insert the symbol, click Cancel button to close the Symbol dialog box. The Cancel button can be changed to the Close button after clicking the Insert button. The Close button is used to close the Symbol dialog box also.

- Click the symbol or special character that you want in the Symbols tab or Special Characters tab.

- Click Insert


- If you cannot find the symbol that you want, you can change the font in the Font box. Some fonts such as Tahoma and Arial are the extended font, so the Subset list appears. Use this list to choose the symbol that you need from the extended list of language characters.

- To quickly find the special character, click Special Characters tab.



This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.