If you work with data related to mathematics, finance, and various scientific fields, you may need to use the infinity symbol (∞) in Excel.
In this article, I will cover some easy methods to insert the Infinity symbol in your Excel spreadsheet.
This Tutorial Covers:
ToggleInsert Infinity Symbol in Excel
Below are some details about the Infinity symbol in Excel.
Details / Methods | Description |
---|---|
Symbol Name | Infinity |
Symbol | ∞ |
Keyboard Shortcut | ALT + 236 |
Formula | =UNICHAR(8734) |
Symbol Dialog Box | You can find the Infinity Symbol in the ‘Mathematical Operators’ subset |
Copy and Paste the Infinity Symbol into Excel
If you want to get the Infinity symbol in Excel only once in a while, it’s best to copy it from some web page on the internet or from another document where you’ve already used it.
Below, I am providing the infinity symbol that you can copy and use in Excel
∞
Keyboard Shortcut to Insert Infinity Symbol in Excel
Below is the keyboard shortcut you can use to get the Infinity symbol in Excel:
ALT + 236
Below are the steps to use this shortcut in Excel:
To use this shortcut, follow these steps:
- Select the cell where you want to get the infinity symbol.
- Press the ALT key.
- Continue to hold the ALT key and press 2, 3, and 6 in sequence.
- Release the ALT key.
As soon as you let go of the ALT key, it inserts the infinity symbol in the cell.
Note: To use the above keyboard shortcut, you need to have a numeric keypad on your keyboard, and the num lock should be ON
Formula to Get the Infinity Symbol
You can also use the below formula to get the infinity symbol in a cell in Excel.
=UNICHAR(8734)
Once you have got the infinity symbol, you can remove the formula if you want. To do this, you can copy the cell and paste it back as a value. This would remove the formula but keep the value.
Also read: Insert Diameter Symbol in Excel
Inserting Infinity Symbol Using the Symbol Dialog Box
Below are the steps to insert the Infinity symbol using the Symbol dialog box in Excel:
- Select the cell where you want the symbol.
- Click the Insert tab in the ribbon.
- Click on the Symbol icon to open the Symbol dialog box.
- Select the ‘Mathematical Operators’ subset from the drop-down.
- Find and double-click on the infinity symbol (∞), or select it and then click the Insert button.
Also read: Insert Registered Trademark Symbol in Excel
Using the Character Map App in Windows
Just like the symbols dialog box in Excel, you can also use the character map app in Windows to insert the infinity symbol in Excel or any other app in Windows.
Below are the steps to use the character map to get the Infinity symbol:
- Search for Character Map in the Windows search bar and open it.
- Check the Advanced View option. This shows some additional options that make it easier to find the Infinity symbol.
- In the ‘Search for‘ field, type ‘infinity’ and press enter. This will show you infinity-related symbols in the symbols grid.
- Double-click on the Infinity symbol, then click on the Copy button.
- Paste it into an Excel cell.
So, these are some of the methods you can use to quickly get the Infinity symbol in a cell in Excel.
If you need to reuse the symbol in multiple places in your worksheet, you can first get the symbol in one of the cells and then copy and paste it wherever you want.
I hope you found this Excel article helpful.
If you know of any other method to insert the Infinity symbol in Excel or you have any feedback on any of the methods covered in this article, do let me know in the comments section.
Other Excel articles you may also like: