This article will help you know how to insert special characters in Excel when you do the processing of monetary statistics tables that need to insert special characters or you can also insert special symbols. , copyrighted …
Job Insert special characters in Excel spreadsheets done not as much as when you process documents, insert special characters into Word but not without. For spreadsheets that need statistics, work with numbers and currencies, use symbols such as dollars, pounds, euros, etc., you need to know how to add characters. especially on spreadsheets in Excel to express the statistics quickly and accurately.
Insert special characters in Excel
Huong guide insert special characters in Excel 2019
In the tutorial below, Taimienphi.vn will help you know how to insert special characters in Excel 2019. The operation will guide you to insert characters with Symbol, use the Alt key combination to insert and finally insert characters with Character Map.
1. Insert characters in Excel with Symbol
Step 1: Open Excel 2019 or you open the spreadsheet to insert characters. Click on the cell where you want to insert the special character -> and then the menu Insert -> select continue to section Symbols -> then click next Symbol.
Step 2: A new interface appears, select the type of symbol you want to insert in the Excel content -> and then click Insert below to insert characters. You can choose other fonts to insert special characters such as: Wingdings, Wingdings 2, Wimgdings 3 to get the characters you want.
The result of the character you inserted into the cell will display as described in the example below:
Step 3: If you want to insert some other special characters, you return to the Symbol interface as in steps 2 -> and then click on the tab Special Characters -> next select the special characters -> select is complete, you click Insert
As a result, you will have other special characters inserted into the content in Excel.
2. Insert special characters with the Alt key combination
In this method, you will use keystrokes Alt + Ordinal numbers to insert different special characters in Excel spreadsheets. You’ll use the numeric keys on the keyboard, turn on Num Lock, and then use the keyboard on the far right to perform special characters.
For example, you want to insert characters that are smileys. Select the cell to be inserted -> and press the key Alt simultaneously press 1 in Num Lock -> then release the key Alt will appear smileys in the cell that you insert.
Here is a list of special characters when using shortcut keys for your reference:
3. Insert special characters with the Character Map
Character Map is a special character table available on Windows computers, so you can use this table to find and insert special characters in Excel.
Step 1: At the search on Windows -> enter the keyword Character Map -> then click on the search result as described in the image below:
Step 2: At the table interface Character Map, click on the font Time New Roman to find characters. Next, click on the character you want to use -> and then click on Select Let the characters show at the frame Character to copy –> then press Copy to (save) the memo to the Clipboard.
Step 3: Finally, click paste (Ctrl + V) at the position you need to insert in Excel is done inserting special characters.
So you’ve just joined us to learn 3 ways to insert special characters in Excel 2019. With the three ways guided in this article, you can depend on your actual use situation to have a suitable choice. Please. Often using Symbol and Charater Map will be simpler because the common rules are to use existing characters. If you use the Alt key combination, you will remember to add the key combination at the back to get the desired results, you refer to Excel 2019 keyboard shortcuts Here to know more hot key combinations to use more economical operation on Excel 2019.