How to Insert Infinity Symbol in Excel?

The infinity symbol (∞) is widely used in various fields, such as mathematics, physics, and philosophy.

It represents the concept of infinity, an unbounded quantity that is greater than any real number. In mathematics, it’s often used in calculus, number theory, and set theory to denote an endless process or quantity.

In this article, I will show you some simple ways to insert the Infinity symbol in Excel

Keyboard Shortcut to Insert Infinity Symbol in Excel

Below are the keyboard shortcuts to insert Infinity symbol in Excel:

On Windows in Excel:

Shortcut: Alt + 236
  1. Ensure Num Lock is on.
  2. Hold down the Alt key.
  3. Type 236 on the numeric keypad.
  4. Release the Alt key to insert the infinity symbol.

On Mac in Excel:

There is no direct keyboard shortcut for the infinity symbol in Excel for Mac. It is usually inserted using the Symbol dialog box or by copying from a character map or some other place/document.

Inserting Infinity using the Symbol Dialog Box

To insert the Infinity symbol in Excel using the Symbol Dialog Box, follow these steps:

  1. Click on the cell where you want to insert the symbol.
  2. Go to the Insert tab on the ribbon.
Click the insert button
  1. Click on Symbol in the Symbols group.
Click on the symbols icon in the ribbon
  1. In the Symbol dialog box, select Mathematical Operators from the Subset dropdown.
Select the Mathematical operator subset
  1. Locate and select the Infinity symbol (∞).
Select the infinity symbol in the symbol dialog box Excel
  1. Click Insert, then close the Symbol dialog box.

The above steps would insert the infinity symbol in the cell that we selected in step 1.

Inserting Infinity Symbol using Formula

You can use the below formula to insert the Infinity symbol in Excel using the UNICHAR formula:

=UNICHAR(8734)

Copy and Paste the Infinity Symbol into Excel

And finally, there is always an option to copy the infinity symbol from any website or document and paste it into a cell in Excel.

You can copy the infinity symbol from below:

Below is a table that summarizes all the methods to insert the Infinity symbol in Excel:

DescriptionDetails
Name of SymbolInfinity Symbol
Symbol Text
Shortcut for WindowsAlt + 236
Shortcut for MacNo direct shortcut; use the Symbol dialog box
Inserting using Symbol Dialog BoxFind ∞ in Mathematical Operators in Symbol dialog box
Inserting using Formula=UNICHAR(8734)

Other Excel articles you may also like:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.

Leave a Comment