How to Insert Infinity Symbol (∞) in Google Sheets (2 Simple Ways)

The infinity symbol is a mathematical symbol. It is sometimes called lemniscate. In this article, you will learn how to insert an infinity symbol in Google Sheets.


A Sample of Practice Spreadsheet


2 Simple Ways to Insert Infinity Symbol in Google Sheets

Let’s assume a data set that contains two rows and two columns. The first column shows the Symbol Name and the second column is for the corresponding Symbol. Suppose you have to enter the symbol infinity in the Symbol column.

sample dataset for how to insert infinity symbol in google sheets


1. Using Keyboard Shortcut

You can easily input an infinity symbol by using a keyboard shortcut in Google Sheets. Follow the steps below.

Steps:

  •  Double-click and select cell C5.

insert of infinity symbol in google sheets using keyboard shortcut

  • Press the ALT+236 from the Numerical pad of the keyboard, release the ALT key, and press ENTER.

inserting infinity symbol in selected cell


2. Applying Copy-Paste Feature

You can copy the Euro symbol from anywhere you want and paste it into the desired cell. It is the easiest way. Here we will discuss Google Docs, Windows Character Map, and Google Search.

Note: To make things easy for you, here’s the infinity symbol for you to copy:

2.1 Using Google Docs

Google Sheets does not have the feature to insert symbols. But you can easily insert symbols in Google Sheets with the help of Google Docs. Here are the steps.

Steps:

  • First, open a document on Google Docs. Then, from the Insert menu, select the Special Characters option.

insert of infinity symbol in google sheets using Google Docs

  • From the Insert special characters tab, select Symbol from the left drop-down options and Maths from the right drop-down options.

  • You can find the symbol by using the search by keyword or code point option. Here, type infinity into the search box.

inserting infinity symbol by typing infinity

  • You can also type the code point U+221E for the infinity symbol into the search box.

insert of infinity symbol typing code point

  • You can also draw the symbol in the box labeled Draw a symbol here. Then, from the options, choose the character.

finding the infinity symbol after drawing

  • Then select the Infinity symbol from the menu to insert it into the Google Document.
  • Close the Insert special characters box. Then Copy the symbol from the Google Doc file.

  • Switch back to Google Sheets. Select cell C5 and Paste the copied symbol.

  • The final output will look like the below screenshot.

final result after inserting the infinity symbol after copy-paste

Read More: How to Insert Division Symbol in Google Sheets (4 Quick Methods)


2.2 Utilizing Windows Character Map

You can use the Character Map feature of Windows to copy-paste a special character into a Google Sheet.

Steps:

  • To navigate the feature, first, search for the Character Map using the Search bar option of windows.

insert of infinity symbol in google sheets utilizing Windows Character Map

  • Select Advanced view, then type the Unicode for the infinity symbol 221E in the Go to Unicode text box.

finding infinity symbol in Character Map

  • Select the symbol to copy. Then click to Copy.

copying the infinity symbol from Character Map

  • Go back to Google Sheets and Paste the symbol on the selected cell.

Read More: How to Insert Check Symbol in Google Sheets (8 Effective Ways)


2.3 Applying Google Search

The simplest way to insert the symbol is to search for it on the web and copy-paste it.

Steps:

  • First, go to the google search bar in your browser and type Infinity or Infinity symbol. You will find the symbol easily in the search results.

insert of infinity symbol in google sheets applying Google search

  • Copy the symbol.

  • Then Paste it on the desired cell.

  • The end result will look like the screenshot below.

paste of infinity symbol in selected cell

Read More: How to Insert Square Root Symbol (√) in Google Sheets (3 Ways)


Conclusion

Following the methods, hopefully, you can easily enter the infinity symbol in the Google Sheets. You can practice on the practice spreadsheet on your own. For further queries or suggestions, please comment below in the comment section. You can find more Google Spreadsheet-related blogs on our OfficeWheel blogs.


Related Articles

Jawadul Islam Chowdhury

Jawadul Islam Chowdhury

Hello! This is Jawad. I create Google Spreadsheets-related content for OfficeWheel. I enjoy doing research and solving Google Spreadsheet-related problems. I love to learn new things and teach them to others.

We will be happy to hear your thoughts

Leave a reply

OfficeWheel
Logo