Teach you to easily insert symbol scores and special characters in Excel

Excel uses the Symbol dialog box to insert symbols (such as ¼ and ©) or special characters (such as a dash (-) or ellipsis (...)) that are not on the keyboard, or to insert Unicode (a character encoding standard developed by Unicode:unicode Consortium). The standard uses more than one byte to represent each character, and implements a single character set that represents almost all of the world's written languages. Characters

The types of symbols and characters that you can insert depend on the font you select. For example, some fonts may contain fractions (¼), international characters (Ç,ë), and international currency symbols (￡,￥). The built-in symbol font contains arrows, bullets, and scientific symbols. There may be other symbolic fonts, such as Wingdings, that contain decorative symbols.

　　Insert a symbol, score, or special character

Note You can increase or decrease the size of the Symbol dialog box by moving the pointer to the lower-right corner of the dialog box until it becomes a double-headed arrow, and then dragging to the desired size.

1, click where you want to insert the symbol.

2, on the Insert tab, in the Text group, click Symbols.

3, in the Symbol dialog box, click the Symbols tab, and then do one of the following:

• Click the symbol you want to insert.

• If the symbol you want to insert is not in the list, select a different font in the Font box, click the font you want, and then click the symbol you want to insert.

Note If you are using an extended font (such as Arial or times New Roman), the subset list appears. Use this list to select from an extended list of language characters, including Greek and Russian (Cyrillic), if any.

4, click "Insert".

Tip To quickly find and insert special characters by means of special characters, click the Special Characters tab in the Symbol dialog box, click the special character you want to insert, and then click Insert.

　　Insert Unicode character

You can insert Unicode characters by selecting a character from the Symbol dialog box or by typing the character code directly.

Select Unicode characters from the Symbol dialog box

When you select a Unicode character in the Symbol dialog box, its character code is displayed in the character code box.

1, click where you want to insert the Unicode character.

2, on the Insert tab, in the Text group, click Symbols.

3, on the Symbols tab, in the Font box, click the font you want.

4, in the From box, click Unicode (hexadecimal).

5, if the "Subset" box is available, click a subset of characters.

6, click the symbol you want to insert, and then click Insert.

7, click "Close".

Inserting Unicode character codes into documents using the keyboard

If you know the character code, you can enter the code into the document and then press ALT+X to convert it to a character. For example, press 002A First, then press ALT+X to generate *. Vice versa. To display the Unicode character code for an existing character in the document, place the insertion point directly after the character, and then press ALT+X.

Find Unicode character code

When you select a Unicode character in the Symbol dialog box, its character code is displayed in the character code box.

1, on the Insert tab, in the Text group, click Symbols.

2, on the Symbols tab, in the Font box, click the font you want.

3, in the From box, click Unicode (hexadecimal).

4, the Unicode character code is displayed in the character code box.

　　Type characters that are not on ¢, £, ¥, ®, and other keyboards

1. Do one of the following:

• In Microsoft Windows Vista, click the Start button

, point to All Programs, attachments, System Tools, and then click Character Map.

• In Microsoft Windows XP, click Start, point to All Programs, attach to attachments, System Tools, and then click Character Map.

Note If Character Map is not available, see Windows Help for information about how to install Windows components.

2, in the Font list, click the font you want to use.

3, click the special character you want. If you don't see the character you want, try clicking a different font in the Font list.

4, click Select, and then click Copy.

5, switch to the document, and then place the cursor where you want to paste the characters.

6, click "Paste".

7. If the inserted character does not look the same as the selected character, select the character and apply the same font as the font selected in Character Map.

Comments

If you know the Unicode that corresponds to the story of the character you want to insert, you can insert special characters directly into your document without using Character Map. To do this, you should open the document and place the cursor where you want the special characters to appear. Then, when Num Lock is turned on, press ALT while pressing the key on the numeric keypad to type the Unicode character value.

If you want to type a slightly more character, you can install and switch to the English (United States)-American English-International keyboard layout.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join