How to insert special characters in Excel

Inserting special characters in Excel is as simple as inserting characters in Word.

The requirement to insert special characters in Excel is not as great as when you handle Word documents that insert symbols into Word, but not without. When we deal with monetary statistics tables, it is mandatory to insert special characters to represent different currencies. Or you can insert brand symbols, copyrights, . many different types of characters depending on the content required in Excel. The following article will guide you how to insert special characters in Excel.

  1. Word 2003: Type page numbers, insert special characters . into a text file
  2. How to insert the C degree icon in Word, Excel?
  3. How to insert characters on Google Docs
  4. How to insert text into images in Excel

1. Insert characters in Excel with Symbol

Step 1:

In the Excel file, click the cell you want to insert a special character in and select the Insert tab . Click Symbols then click on Symbol.

How to insert special characters in Excel Picture 1How to insert special characters in Excel Picture 1

Step 2:

Select the type of icon that the user wants to insert in Excel content, then click the Insert button below to insert the character. We can choose fonts like Wingdings, Wingdings 2, and Wimgdings 3 to have other special characters.

How to insert special characters in Excel Picture 2How to insert special characters in Excel Picture 2

Character results were inserted in place on Excel.

How to insert special characters in Excel Picture 3How to insert special characters in Excel Picture 3

Step 3:

Go back to the character board interface and click on Special Characters to insert some other special characters.

How to insert special characters in Excel Picture 4How to insert special characters in Excel Picture 4

The result also adds other characters that are inserted into the content in Excel.

How to insert special characters in Excel Picture 5How to insert special characters in Excel Picture 5

2. Insert characters in Excel with the Alt key combination

We will use the Alt key + sequence number to produce different special characters. You use the number keys on the keyboard and turn on Num Lock, use the keyboard on the right end to effectively insert special characters.

How to insert special characters in Excel Picture 6How to insert special characters in Excel Picture 6

List of special characters according to the shortcut combination you refer to below.

How to insert special characters in Excel Picture 7How to insert special characters in Excel Picture 7

How to insert special characters in Excel Picture 8How to insert special characters in Excel Picture 8

How to insert special characters in Excel Picture 9How to insert special characters in Excel Picture 9

How to insert special characters in Excel Picture 10How to insert special characters in Excel Picture 10

3. Insert characters in Excel with Character Map

Character Map is a special character table available on Windows computers and we can use this table to find characters for Excel content.

Step 1:

In the search bar on Windows enter the Character Map keyword and click on the search result.

How to insert special characters in Excel Picture 11How to insert special characters in Excel Picture 11

Step 2:

Display the Character Map panel, click the Time New Roman font to find the character. Then you just need to click on the character you want to use , click on Select to display the character in the Character to copy frame and then click Copy to save it to the Clipboard.

How to insert special characters in Excel Picture 12How to insert special characters in Excel Picture 12

Then click paste at the position you want to insert in Excel.

How to insert special characters in Excel Picture 13How to insert special characters in Excel Picture 13

These are 3 different ways to insert special characters in Excel. Symbol and Charater Map usage is simpler when characters are available. If you use the Alt key combination, you must remember to add the number key combination behind to show the correct characters.

I wish you all success!

5 ★ | 2 Vote