How to insert special characters in Excel 2019


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.

How to insert special characters in Excel 2019 2

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.

How to insert special characters in Excel 2019 3

The result of the character you inserted into the cell will display as described in the example below:

How to insert special characters in Excel 2019 4

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

How to insert special characters in Excel 2019 5

As a result, you will have other special characters inserted into the content in Excel.

How to insert special characters in Excel 2019 6

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.

How to insert special characters in Excel 2019 7

Here is a list of special characters when using shortcut keys for your reference:

How to insert special characters in Excel 2019 8

How to insert special characters in Excel 2019 9

How to insert special characters in Excel 2019 10

How to insert special characters in Excel 2019 11

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:

How to insert special characters in Excel 2019 12

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.

How to insert special characters in Excel 2019 13

Step 3: Finally, click paste (Ctrl + V) at the position you need to insert in Excel is done inserting special characters.

How to insert special characters in Excel 2019 14

https://thuthuat.taimienphi.vn/cach-chen-ky-tu-dac-biet-rong-excel-2019-53474n.aspx
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.

.

Add a Comment

Your email address will not be published. Required fields are marked *