When we have to insert some special symbols in Excel, but there is no shortcut key for us to use. The article will show 2 methods to help you find these special symbols. Let’s take equal approximately symbol as an example.
Method 1: Insert Approximately Equal Symbol
First, open the form you want to edit.
![Methods To Insert Euqal Approximately Symbol Methods To Insert Euqal Approximately Symbol](https://www.myofficetricks.com/wp-content/uploads/2020/08/image.png)
Second, click the cell where you want to insert the symbol, and then click Insert.
![Methods To Insert Euqal Approximately Symbol Methods To Insert Euqal Approximately Symbol](https://www.myofficetricks.com/wp-content/uploads/2020/08/image-1.png)
Then click Symbol, you will see the following interface.
![Methods To Insert Euqal Approximately Symbol Methods To Insert Euqal Approximately Symbol](https://www.myofficetricks.com/wp-content/uploads/2020/08/image-2.png)
Then find Font, selecting Symbol, and you will see this interface.
![Methods To Insert Euqal Approximately Symbol Methods To Insert Euqal Approximately Symbol](https://www.myofficetricks.com/wp-content/uploads/2020/08/image-3.png)
Find ≈ , click Insert and then click Close, the Approximately Equal Symbol is inserted in the cell.
![Methods To Insert Euqal Approximately Symbol Methods To Insert Euqal Approximately Symbol](https://www.myofficetricks.com/wp-content/uploads/2020/08/image-4.png)
The whole process is as follow.
![Methods To Insert Euqal Approximately Symbol Methods To Insert Euqal Approximately Symbol](https://www.myofficetricks.com/wp-content/uploads/2020/08/1.gif)
Method 2: Type Approximately Equal Symbol Directly
The drop-down list may be a tedious process, and actually you can type approximately equal sysmbol with shortcut keys.
First, open the form you want to edit.
![Methods To Insert Euqal Approximately Symbol Methods To Insert Euqal Approximately Symbol](https://www.myofficetricks.com/wp-content/uploads/2020/08/image-6.png)
Second, click the cell where you want to insert the symbol, and then click Insert.
![Methods To Insert Euqal Approximately Symbol Methods To Insert Euqal Approximately Symbol](https://www.myofficetricks.com/wp-content/uploads/2020/08/image-7.png)
Then, click Text, there will be a drop-down list, click Object.
![Methods To Insert Euqal Approximately Symbol Methods To Insert Euqal Approximately Symbol](https://www.myofficetricks.com/wp-content/uploads/2020/08/image-8.png)
And then find the Microsoft Equation 3.0 in the drop-down list of the Create New, then click OK. You will see the following interface.
![Methods To Insert Euqal Approximately Symbol Methods To Insert Euqal Approximately Symbol](https://www.myofficetricks.com/wp-content/uploads/2020/08/image-9.png)
Then click the first column, find the ≈, and deletethe Equation column, the Approximately equal symbol is in the cell.
![Methods To Insert Euqal Approximately Symbol Methods To Insert Euqal Approximately Symbol](https://www.myofficetricks.com/wp-content/uploads/2020/08/image-10.png)
The whole process is as follow.
![Methods To Insert Euqal Approximately Symbol Methods To Insert Euqal Approximately Symbol](https://www.myofficetricks.com/wp-content/uploads/2020/08/2.gif)
I hope the two methods can be helpful to you.
Leave a Reply