Insert Infinity Symbol in Excel

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.

Insert Infinity Symbol in Excel

Below are some details about the Infinity symbol in Excel.

Details / MethodsDescription
Symbol NameInfinity
Symbol
Keyboard ShortcutALT + 236
Formula=UNICHAR(8734)
Symbol Dialog BoxYou 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:

  1. Select the cell where you want to get the infinity symbol.
  2. Press the ALT key.
  3. Continue to hold the ALT key and press 2, 3, and 6 in sequence.
  4. 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)
UNICHAR formula to get the infinity symbol in Excel

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:

  1. Select the cell where you want the symbol.
  2. Click the Insert tab in the ribbon.
insert tab in the ribbon to get symbols
  1. Click on the Symbol icon to open the Symbol dialog box.
Click on the symbol icon in Excel Ribbon
  1. Select the ‘Mathematical Operators’ subset from the drop-down.
Select Mathematical operators from the subset drop down
  1. Find and double-click on the infinity symbol (∞), or select it and then click the Insert button.
Select  and insert the infinity symbol
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:

  1. Search for Character Map in the Windows search bar and open it.
Open the character map app in windows
  1. Check the Advanced View option. This shows some additional options that make it easier to find the Infinity symbol.
Click the Advanced View option in Character Map dialog box
  1. In the ‘Search for‘ field, type ‘infinity’ and press enter. This will show you infinity-related symbols in the symbols grid.
Enter Infinity in the search for field in the character map dialog box
  1. Double-click on the Infinity symbol, then click on the Copy button.
Copy the Infinity symbol from the character map dialog box
  1. 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:

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.
Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster